Forcing DTS to append a CSV....

[NSMan]

Is there a way to make a DTS package append a CSV file rather than overwrite it? I've been searching the documentation, and have come up empty handed thus far.....

 

[Catadmin]

Look into the DTS Import/Export Wizard. When you get to the third or fourth screen, there is a Transform button you can hit which, after the initial "table" is created, you should be able to choose the "Append" option.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!