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.
| Author |
Topic |
|
rsimon
Starting Member
2 Posts |
 Posted - 2011-07-08 : 14:17:37
|
| I am unable to run a ssis package from the sql server agent. Although when I execute it from the integration services it runs and from my local machine too. Here is the error that I am getting. MessageExecuted as user: userid. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:05:23 AM Error: 2011-07-08 11:05:26.84 Code: 0xC020200E Source: packagename DataFlow filename Text File [62] Description: Cannot open the datafile "\\nwpathname\dir\subdir\filename.txt". End Error Error: 2011-07-08 11:05:26.84 Code: 0xC004701A Source: packagename DataFlow SSIS.Pipeline Description: component "filename Text File" (62) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:05:23 AM Finished: 11:05:26 AM Elapsed: 2.985 seconds. The package execution failed. The step failed.Please help !! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-08 : 19:25:28
|
| Set the protection level of the package to "Rely on server storage."Make sure the SQL Agent account has permissions on all objects, files etc. that the SSIS package touches. |
 |
|
|
lightsql
Starting Member
17 Posts |
Posted - 2011-07-20 : 05:28:58
|
| As russell said, you may not have permission on the location of your data file. Try creating a proxy account with matching credential. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-20 : 07:48:14
|
| are you using proxy account for running package from job?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
unable to run a ssis package sql server agent