How to Copy Files in SSIS
To copy files in SSIS all you need to do is follow these simple steps.
Overall View:
The first step is to define few variables in the system:.bmp)
1.“uVar_BackupFolder” this is the folder that the files will be copied to, you must create this folder before running the package, this package does not make folder.
2.“uVar_FolderNameOfFilesToBeProcessed” Points to the folder that is required to be processed.
3.“uVar_SourceConStr_DataSource” File name and folder gets saved in on each loop
4.“uVar_SourceFileExtention” Defines the file extension type.
Next, we must configure the settings of the Loop:
First ---.bmp)
Second --.bmp)
The final step, setting FSYS.bmp)
.bmp)
Testing Scenarios
Assuming that we have 2 excel files in 2 different folders....bmp)
Simply run the package from BIDS and check the backup folder and see
.bmp)
.bmp)
.bmp)
.bmp)
.bmp)
.bmp)