I will be importing about 20 CSV files nightly into a SQL 2008 database. I would like to use a separate dtsx package for each file that I’m importing and these 20 dtsx are contained in a sequence container as I will have task to perform before and after loading these files.
My question is how to use the configuration file (dtsConfig) of the main dtsx package to point to the 20 separate dtsx packages? I’m trying not to use 21 separate dtsConfig files as all of these csv files will be in the same folder and the destination database will also be the same for all.
I have attached an example of the package.