Post reply

Temporary table in DTS

  • September 17, 2003 at 10:32 am

    #358350

    Is it possible to create, then use, then delete a temporary table in DTS.

    How do I do this?

  • September 17, 2003 at 1:46 pm

    #474743

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

  • September 17, 2003 at 2:44 pm

    #474750

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

  • September 18, 2003 at 3:14 am

    #474824

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

  • September 18, 2003 at 5:21 am

    #474841

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

  • September 18, 2003 at 6:11 pm

    #474964

    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

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

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