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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-19 : 09:28:41
|
| Justin writes "Hi,I am in the process of trying to convert all SQL 2000 DTS packages to SSIS. I have one old package that contains only an ActiveX Script Task. I have completely converted that to an SSIS Script Task and rewrote the code using VB.Net. The script starts out by calling a stored procedure which creates three separate global temporary tables (##temp_1, etc.). The tables have 1K, 5K, and 20K rows with 5 columns each. Those tables are used and referenced in other SQL statments in the .Net code. The problem is that by the time one of the temp tables is referenced in another SQL statement it has already been dropped in the tempdb. Nothing like this ever happened on SQL 2000. I'm not sure why it's happening in 2005. Any suggestions on what I can look at in order to persist those temp tables for a longer amount of time?Thanks in advance!Justin" |
|
|
|
|
|
SQL 2005 Global Temp Tables losing scope