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 |
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
 Posted - 2009-04-09 : 20:03:57
|
| I have a job that runs an SSIS package which writes to a network share. The package runs fine, but when I run it under a job, it fails. The Account under which the agent runs is an Admin account and has full control on the destination it is writing to. Can anyone please help. The error I Get is Move Source Data to CSV OLE Patient Data on VW_PRODUCTION [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. End Error Error: 2009-04-09 16:53:34.78 Code: 0xC02020E8 Source: DFT Move Source Data to CSV OLE Patient Data on VW_PRODUCTION [1] Description: Opening a rowset for "[dbo].[VW_CBAY_DATA_NG]" failed. Check that the object exists in the database. End Error Error: 2009-04-09 16:53:34.78 Code: 0xC004706B Source: DFT Move Source Data to CSV DTS.Pipeline Description: "component "OLE Patient Data on VW_PRODUCTION" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2009-04-09 16:53:34.78 Code: 0xC004700C Source: DF... The package execution fa... The step failed. |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2009-04-09 : 21:09:47
|
| It was due to my linked server mappings. The problem is now resolved. |
 |
|
|
|
|
|
SSIS Package Job Failing