alaaShamas


Hello kindly help me in this issue , i have an ssis package with excel data source , when i run it outside the sql

agent job it run normaly when i create a job to execute it from the sql server agent it fail.

can any body help me.

also i had same problem with packages that call the execution of other packages.





Re: SSIS with excel source faile to execute from SQL agent

jwelch


It sounds like a security issue. Have you validated that the account that SQL Agent is running under has access to the file





Re: SSIS with excel source faile to execute from SQL agent

alaaShamas

yes it has access to the files actuly if you run from sql agent job any other t ype of packages that has directly oledbsources in it, it works but whenver there is an excel datasource or a package execution task in side the package am running it will not execute from the agent although it run normally outside.





Re: SSIS with excel source faile to execute from SQL agent

jwelch

What's the actual SSIS error message (not the SQL Agent log message)




Re: SSIS with excel source faile to execute from SQL agent

Michael Entin - MSFT

Please see this KB for troubleshooting suggestions:

http://support.microsoft.com/kb/918760

Please enable the logging as suggested by KB and then post the error(s) that you get.