Global Temporary Tables in DTS

[Modica82]

Hi all, is it possible to create a Global Temporary table in a DTS, fill it wil information, use it for a transformation and then destroy it within one package?? If not, what are the alternatives?

Regards,

Rob

 

[tb]

I'm not sure I understand what you mean by "Global Temporary " table ..??

But ... I create my all temp tables with a SQL Task at the beginning of the DTS. Then transfer the data, execute a Axtive X Script to call my stored proc, then drop the table at the end with a SQL Task.


I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[jhall01]

You can always create ##temp or #temp tables using a Execute SQL Task.

#temp are local temp tables and are only available during the session.

##temp tables are global temp tables and are available to all users and connections

My suggestion is put a Execute SQL Task at the beginning of your DTS that creates the table. Then at the end once you are done add another Execute SQL Task that drops the table.

Jon

 

[Modica82]

Hi all,

i have created a 'permanent/temporary' table in temp DB, as according to books online this is a better approach then creating a tempory table. It seems to work, and i am glad that my way of thinking is the same as yours .

Thanks for your help!

Rob