Friday, November 13, 2009

Coping files in SSIS

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:

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 ---

Second --

The final step, setting FSYS

Testing Scenarios
Assuming that we have 2 excel files in 2 different folders...

Simply run the package from BIDS and check the backup folder and see