Post reply

Temporary table

  • September 1, 2004 at 9:46 pm

    #60418

    I am working on a project that requires use of temporary tables (##tempTbl) in DTS. I used a 'Execute SQL Task' to create a global temporary table.  In the next step 'Transform Data Task' I wanted to copy excel data in this temporary table. But it gives me errors. It says something like 'Invalid object name ##tempTbl'.

    I know I am doing wrong.  How should the temporary tables be used in DTS.

    Thanks

    Arpan

     

     

  • September 2, 2004 at 5:31 am

    #521478

    If you are trying to directly reference the #table it will not work.  You will have to do the code inside a stored procedure.  The problem is the system looks for an object to verify the columnar paths, etc...  and can't because the object doesn't exist.

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 2, 2004 at 7:18 am

    #521500

    I have an excel spreadsheet downloaded using http://ftp.  The excel spreadsheet contains hundreds of rows, but I want to extract only certain required rows. I therefore require temp tables. 

    If you can please explain how to use temp tables within stored procedure, your help would be greatly appreciated.

    Thanks, Arpan

  • September 2, 2004 at 4:57 pm

    #521568

    An easier solution would be to create a STAGING type table import your EXCEL data into that "real" table and then grab the data you want out of it.

    OR

    You could build an application to load into SQL from the Excel file

    OR

    You could....

    I would build a real table that gets truncated after every run that sounds to be the easiest for you.

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 2, 2004 at 7:56 pm

    #521572

    Thanks for your answer.  I am building real tables and dropping after every run.  I was just thinking about creating temp tables.

    Thanks again for your response.

     

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

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