May 7, 2004 at 5:04 am
Hi all,
When I running my DTS package, it sign an SQL error:
SQL Error: The current user is not the database or object owner of table '#tmp_PkgLog'. Cannot perfom SET operation.
My god, I don't understand!
What's means this message?
I don't know the object #tmp_PkgLog
It's a temporary table?, but I don't create it in my package (or in my
stored procedures launched by package)
Can you Help me???
Thanks
May 10, 2004 at 8:00 am
This was removed by the editor as SPAM
May 10, 2004 at 9:14 am
Just a shot in the dark here.
Are you trying to write the outcome of the job to a log file. If so, it may be storing the data in the table mentioned.
Try selecting from the table as well and see what is in it if it is not being deleted each time you run the job.
Also, let me know what it is you are doing in the dts package. It may give a clue.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply