DTS & temporary objects

  • I can't use DTS with temporary tables or procedures using temporary tables inside.

    Why? Because of several DTS connections?

    Using of global temporary tables is unacceptable, because of multiuser nature of this procs.

    What can I do?

  • I had a similar problem. It wasn't due to several connections, but rather to scope issues - the transformation didn't have access to the temp table because it was out of scope ie had been committed, so I used global temporary tables whose name was guaranteed to be unique per user.

    Paul Ibison

    Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

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

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