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.