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 - 2001-10-29 : 09:09:56
|
| Leo writes "I am trying to automate a Job using the DTS Package. I can run the job by hand fine. If I schedule it I get the following error. ... DTSRun: Executing... DTSRun OnStart: Delete from Table [triple_gsd_live].[dbo].[GSD_Instr_Alt_Id_Type] Step DTSRun OnFinish: Delete from Table [triple_gsd_live].[dbo].[GSD_Instr_Alt_Id_Type] Step DTSRun OnStart: Copy Data from Results to [triple_gsd_live].[dbo].[GSD_Instr_Alt_Id_Type] Step DTSRun OnError: Copy Data from Results to [triple_gsd_live].[dbo].[GSD_Instr_Alt_Id_Type] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 160 (A0) Error string: Specified driver could not be loaded... Process Exit Code 1. The step failed.I assume it is a permissions problem with the SQL Agent but what permissions does it need.I am copying data from a Unix Box (Sybase) to SQL Server 7 on NT 4. I am using ODBC connections, which are defined on the SQL SERVER, I am not running the jobs from a workstation. The ODBC is using a System DSN not a user DSN. Help :-)" |
|
|
|
|
|
DTS on MS SQL SERVER 7 Service Pack 3