July 9, 2016

SSIS upload a files in folder

SSIS Scenario Based Question

Consider a scenario where you have to upload 4 files into SQL server from folder daily.
Client has requirement that if there are only 3 files are available out of 4 files then also our package should execute with those 3 files and load those 3 files into server.

Provided that your file format is different for all the files and destination tables are also different.

To solve this problem we have to write a package with dynamic Enable and disable attribute of a container or data flow task

Create few variables to enable and disable the task.

In this script task we need to write a logic to read the file from the provided folder and based on the file availability we set value to variables

In the data flow task we need write logic to upload the file.


No comments:

Post a Comment