Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    England
    Posts
    15

    Unanswered: Set DTS Destination as temp table?

    Hi

    My DTS package does nothing special it just pulls in an data from another server (specifying the SQL in a Global V).

    This data is then altered using various Stored Procedures.

    What would be nice is if the data's destination table could be a #temp table (within tempdb) and then my sps could access it and perform their various operations.

    At the moment i cannot get this to work and instead all i can think of is to Create a table within the main working db and insert the data into that and then insert the data into a #temp table and DROP the table i created in the working database.

    There must be a better way to achieve this.
    Is there any way to copy the data straight to the #temp table i have created?

  2. #2
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40

    Re: Set DTS Destination as temp table?

    Tom:

    If you're using an ActiveX component in your Package to do the SP calls, try adding VBScript code to create the Temp Table & leave your connection to the GlobalVar SQL instance open.

    BOL has plenty of examples if you need one.

    Hope this helps.
    Sunny Times...

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also check http://www.sqldts.com for DTS goodies.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Location
    England
    Posts
    15
    Thanks for the help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •