Post reply

Error during designing new DTS package

  • January 4, 2007 at 8:46 am

    #90874

    (This is about the first time I've tried to design one of these!)

    adding the 'execute sql task' properties -

    'exec getmailqueue' being the sql, a proc to create a temp table and populate it -

    I get 'invalid object name - '#temptable' when I try to parse.

    Why?

  • January 4, 2007 at 9:12 am

    #681243

    If you have multiple statements in the task, they're each separate. When you run the proc, the temp table exists, but it should go out of scope when the proc ends.

    Why not call getmailqueue from the proc itself?

  • January 5, 2007 at 2:47 am

    #681409

    (of course.... duh!)

    so obvious (blush)

    Yeah - just have to switch the proc around a little.

    thanks for pointing that out!

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

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