Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS Dynamic destination table Expand / Collapse
Author
Message
Posted Monday, January 25, 2010 5:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
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"
Post #852938
Posted Tuesday, February 2, 2010 10:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
Hi experts ... any ideas ?

"Keep Trying"
Post #858390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse