DTS error runs manually but not through DTS

[dwight1]

I have set up a DTS that transfers data from MS Access to Sql DB. When i execute it manually it runs but when i schedule a DTS it complains. It is asking me for the login and i do not have any login as we use Windows Authentication. The error is as follows,

Error = -2147467259 (80004005) Error string: Cannot open database requested in login 'JHData'. Login fails. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 4060 (FDC) Error string: Cannot open database requested in login 'JackHenryData'. Login fails. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Delete from Table [JackHenryData]... Process Exit Code 5. The step failed.

Any Ideas please.

Dwight

 

[philhege]

Under what account does the job run? Check it out in the Jobs node under SQL Server Agent. The job should have the same name as your DTS package.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.