DTS Dynamic destination table

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  January 25, 2010 at 5:58 am

  #100052

  Hi

  I need to design a DTS package where the destination sql server table is dynamic based on the input file recivied.

  The input files are based on different US states. So if the input file is 'CA.txt' then the destination table is 'CaliforniaK1_dtl' and if the input file is 'CA2.txt' then the destination table is 'CaliforniaK2_dtl'.

  There are 9 input files for 4 states. I do not want to create a total of 36 packages for this scenario.

  Thanks in advance.

  "Keep Trying"

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  February 2, 2010 at 10:38 pm

  #1112642

  Hi experts ... any ideas ?

  "Keep Trying"