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.
