Dynamic Destination Tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dynamic Destination Tables

Hello Everybody!<br /><br />I’m new to DTS.<br /><br />Plse suggest me a link where i can find a suitable example of how to dynamically change destination table name in the DTS itself.<br /><br />Need to transform data from one server to another. Destination table is based on dates i.e. Order_31_8_06. I can’t see a method attach to Tranform Task & Data driven Task that allows me to change destination table name dynamically.<br /><br />Looking forward for the prompt reply [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />- V%<br /><br /><br /><br />
For DTS,http://www.sqldts.com/ is very good site indeed. Knowledge is not Power !!!
But When its acted upon then its Power !!!