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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-28 : 07:23:41
|
| Ja writes "I know this is a common problem, but here goes:I have a DTS package running fine when executing from EM. When scheduling as a job, it fails with the following message:Delete from Table [MAS90_test].[dbo].[AP1_VendorMaster] Step DTSRun OnFinish: Delete from Table [MAS90_test].[dbo].[AP1_VendorMaster] Step DTSRun OnStart: Copy Data from AP1_VendorMaster to [MAS90_test].[dbo].[AP1_VendorMaster] Step DTSRun OnError: Copy Data from AP1_VendorMaster to [MAS90_test].[dbo].[AP1_VendorMaster] Step, Error = -2147467259 (80004005) Error string: [Best Canada][PVX ODBC Driver][FILEIO]Table is not accesible Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 12 (C) Error string: [Best Canada][PVX ODBC Driver][FILEIO]Table is not accesible Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from AP1_VendorMaster to [MAS90_test].[dbo].[AP1_VendorMaster] Step DTSRun... Process Exit Code 4. The step failed.The kicker is that it worked before. I was "told" that nothing has changed, by the developers.The account starting SQL server agent is the same account as the creator of the package and the job owner, and is also in the sysadmin server role and respective database dbo." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-28 : 07:44:50
|
| [Best Canada][PVX ODBC Driver][FILEIO]Table is not accesible That's about all you have there that is useful.Try running it from EM on the server.Looks like that table has changed or something has happened to the odbc def on the server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 03:40:12
|
quote:
Originally posted by AskSQLTeam
The kicker is that it worked before. I was "told" that nothing has changed, by the developers.
don't always believe what you are told, they may not have consciously know they changed something or saving face. |
|
|
|
|
|
|
DTS Package Fails When Scheduled