Hello

I have created a package to import tables from a second server using a copy
sql objects task, and I have run into a little snag.

My connection to the external SQL server uses my windows domain account
(server uses ONLY windows authentication) and my connection to my SQL server
i can use a SQL account (sa).

The problem I'm having is I need this package to run at 11pm every night.
Seeing as I wont be able to do this, how can I have the DTS impersonate my
credentials? I have the task set using NT authentication and my domain
account is set as the owner of the job and the package, but this failed
saying
"The job failed. Unable to determin if the owner (domain\myaccount) of job
Import Objects has server access (reason: Could not obtain information about
Windows NT group/user 'domain\myaccount' SQLSTATE 32000 error 8198"

Both severs are SQL Server 2000 (with the sp3a I believe)

Thanks for any and all help.

Hello Ben ben_1_ AT hotmail DOT com,

When a package is run as a job it can take on different credentials to the
ones you think it should be using

Have a read of this and hopefully it will help

http://support.microsoft.com/?kbid=269074

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Looks like my problem is the server im trying to copy objects too uses a
local system account to start up as while im trying to use a domain account
for authentication.

Thanks again.

"Allan Mitchell" wrote: