Dynamic connection managers

• Roust_m

  SSCoach

  Points: 17408

  More actions

  March 1, 2015 at 9:35 pm

  #315149

  Hi,

  I am designing a package to export staging tables into a flat file.

  The names of the tables will be: TableAStaging_YYYYMM and TableBStaging_YYYYMM. As you can see the names of the tables will be changing each month.

  The flat files will have similar naming: C:\MyPath\FlatFileTableAStaging__YYYYMM and C:\MyPath\FlatFileTableAStaging__YYYYMM.

  I want to run the package as an sql job in two steps, one for each table.

  I need to dynamically pass the table names and file names (together with the path) to the IS package.

  What would be the best way to do this?

  Thanks,

• laurie-789651

  SSCertifiable

  Points: 7680

  More actions

  March 2, 2015 at 2:31 am

  #1781052

  If you run the package using DTEXEC, you can change the connections at run time using a parameter (/CONN) - so that might work.