SSIS||Steps to Move particular text Files into Folder using File System Task

Опубликовано: 04 Октябрь 2024
на канале: LearnSQLtoSSIS
86
2

1. Two variables Destination and Filename
2. Drag ForEachLoop Container into Control Flow Pane
Select ForEach File Enumerator
Browse the folder and mention filename of txt files
3. FileSyatemTask inside ForEachLoop Container
Select DestinationPath variable
Change the Operation type to Move the file
Select the newconnection from SourceConnection
4. Select the properties of the source connection
and write an expression for the connection string property