Temporary table in DTS

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

mightyjoemad Mr or Mrs. 500 Points: 586 More actions · Answer 1

You can use SQL Tasks to create the table, use it and then using another Sql Task to delete the table

ghughes SSCrazy Points: 2201 More actions · Answer 2

I do it all the time. Just drop the table after you use it.

StefanJ SSCarpal Tunnel Points: 4713 More actions · Answer 3

Sorry, I did not make myself clear. I meant a temporary table as in #Temp

aruninbox Newbie Points: 5 More actions · Answer 4

U cant do any thing to #table or ##table in DTS.

philcart SSC-Forever Points: 47795 More actions · Answer 5

What do you need to use a temp table for?

Maybe you could assign the rowset to a Global variable and use it like an ADO recordset.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface