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)
 temporary tables in DTS

Author  Topic 

dcobb
Yak Posting Veteran

76 Posts

Posted - 2005-09-01 : 03:42:09
I'm trying to run this SQL in a DTS package with transactions enabled...

CREATE TABLE #t(myfield char(3))
insert into #t (myfield) values ('moo')
drop table #t

And I get this error from DTS when I try and parse the SQL:

Invalid object name #t

I've tried global temporary tables and I get the same message.

Help!
   

- Advertisement -