Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS - Not able to create a Temp table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-02 : 08:11:01
Lavanya writes "Hi
I wrote a DTS Package to retrive data from various tables and return results in a text file.I created a temp table to hold datas for me at different select statements and then tried to return it.My Query analyzer ran it just fine, but DTS is not willing to do so. Is there a way I could do this, without combing the different select statements into one.

Thankyou"
   

- Advertisement -