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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2011-06-01 : 14:16:00
|
| I have a simple package which reads from a DB2 table, and writes the records to a shared location as an Excel file.The package runs with no issues from within Visual Studio.When implemented as a SQL Job, I get the following error.Security appears to be valid on the shared destination location.I also tried using a mapped drive in place of the hard coded server location shown below."\\server\share\file.xls" specified in the connection was not valid. End Error Error: 2011-06-01 14:03:38.30 Code: 0xC001401D Source: Package Step Name Description: Connection "Flat File Connection Manager" failed validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:03:37 PM Finished: 2:03:38 PM Elapsed: 0.657 seconds. The package execution failed. The step failed. |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-06-01 : 15:09:24
|
| check these article:http://www.sqlservercentral.com/Forums/Topic562906-149-1.aspx#bm1080807 |
 |
|
|
|
|
|
Package Wont Run from Scheduled Job