Some help needed. I created a DTS package in SQL Server 2000.
When I created the DTS package I was logged on with my own username.
I then logged on as Administrator to schedule the package, but
one of the steps keep saying Invalid object and the table name.
If I log on with my own username the DTS package works fine, but
when the Administrator log on and try to execute the package it says
Invalid Object and the table names.
Everything runs on the same server.
Is this some sort of permission issue??
When referencing objects using the one-part naming convention, the database will first look for an object by that name which belongs to that user. If it cannot find one, it will look for an object by that name which belongs to the dbo.
So logged in as yourself, the server quickly finds the object that you are looking for that has the matching name and belongs to your schema.
But when logged in as admin, the server will NOT look for objects owned by other schemas.
Resolution: either change the ownership of your object to "dbo", or use the two-part naming convention to specify the owner: [Owner].[Object].
If it's not practically useful, then it's practically useless.