Post reply

procedure failing when called from DTS

  • June 18, 2003 at 8:55 pm

    #462028

    I am no very sure but I think temp tables are not permitted on the DTS packages.

    you can verify it for yourself.

  • June 19, 2003 at 2:40 am

    #462059

    Hi

    it doesn't seem to matter if it is a temporary table or a physical table - parsing the query in the Exec SQL task complains about the table name, wherever it is located ????

    any other ideas?

    thanks

    Ryan

  • June 19, 2003 at 3:30 am

    #462066

    If you are using the temp table in another DTS object you will need to make it global ie ##fileexists

    Steven

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

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