Package fails when runing thru a job

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Package fails when runing thru a job

Author

Topic

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-09-08 : 13:25:02

Please I need help
What I am missing
I have ssis package that reads xml files from a folder on a network drive
The ssis executes fine on right clicking the package name and execute
I even tried setting Run64bitruntime to false
I build the package and save it on sql server packages
Added a proxy
Added the user who created the package (myself) as a principal for this proxy
Added my window’s account i.e. servername/myloginname as a user to the database
Give that login permission to my database
Added this window’s authentication account as a user of msdb
Add this window’s authentication account to the ssisoperator role in msdb
Gave full control to that network drive to sql account and that window’s authenticated (myaccount)
Added a job
Added the package as a step defined my window’s authenticated account login as the owner
Specified that the package run as the proxy previously created
Scheduled the job
The job does not work it gives me failure message
Saying Source: Sort The List of Incomming xmls Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.DirectoryNotFoundException: Could not find a part of the path 'L:\datafiles'. at System.IO.__Error.WinIOError(Int32 errorCode<c/> String maybeFullPath) at System.IO.Directory.InternalGetFileDirectoryNames(String path<c/> String userPathOriginal<c/> String searchPattern<c/> Boolean includeFiles<c/> Boolean includeDirs<c/> SearchOption searchOption) at System.IO.Directory.GetFiles(String path<c/> String searchPattern<c/> SearchOption searchOption) at System.IO.Directory.GetFiles(String path) at ST_b75640dfd4ca4758a401c29858e7ef3f.csproj.ScriptMain.Main()

sarah

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-08 : 13:45:09

Grant permissions to the SQL Agent service account.

Also, make sure you're using UNC paths and not mapped drives if resource is in a remote location.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-08 : 15:22:39

Same as giving any other user permissions. Have your network admin do this for you.

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-09-08 : 16:09:31

thanks a lot

sarah

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources