Using Global Temp table in DTS

[VenkatSQL]

How to use the Global temp table in 'Transform data task properties'

I'm using the Transform Data Task. That's where I declared my SQL query.


Thanks

S.V

 

[mrdenny]

You are better off using a physical table. Global temp tables are dropped when all sessions using them have exited. DTS is serial so after the data is loaded that connection would close and the table would be dropped before the next process could be started.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog