 | |
Errror executing DTS from SQLAgent
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Errror executing DTS from SQLAgent -
08-13-2004
, 03:14 PM
#2
| |||
| |||
|
|
When i'm trying tu execute a DTS package from a job of SQL Agent an error occurre: Does anybody know why it happen? Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 13/08/2004 Time: 17:01:18 User: N/A Computer: KPATOT07 Description: SQL Server Scheduled Job 'SIMDW_Foto_Pedidos_' (0x39EE868A12CCFF4FB2E3B2E565593DA6) - Status: Failed - Invoked on: 2004-08-13 17:01:07 - Message: The job failed. The Job was invoked by User harriague. The last step to run was step 1 (DTS_Foto_Pedido). |
#3
| |||
| |||
|
|
You would need to give us more output fromt he job but in general this helps with DTS and Agent http://support.microsoft.com/?kbid=269074 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Federico Haedo" <fhaedo (AT) harriague (DOT) com.ar> wrote in message news:e8DJZIXgEHA.3548 (AT) TK2MSFTNGP09 (DOT) phx.gbl... When i'm trying tu execute a DTS package from a job of SQL Agent an error occurre: Does anybody know why it happen? Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 13/08/2004 Time: 17:01:18 User: N/A Computer: KPATOT07 Description: SQL Server Scheduled Job 'SIMDW_Foto_Pedidos_' (0x39EE868A12CCFF4FB2E3B2E565593DA6) - Status: Failed - Invoked on: 2004-08-13 17:01:07 - Message: The job failed. The Job was invoked by User harriague. The last step to run was step 1 (DTS_Foto_Pedido). |
#4
| |||
| |||
|
|
From the DTS interface there is no Error. But from the Agent, the job gives the next Error: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 2004 (7D4) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 2004 (7D4) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> escribió en el mensaje news:uZYzJ6dgEHA.1972 (AT) TK2MSFTNGP09 (DOT) phx.gbl... You would need to give us more output fromt he job but in general this helps with DTS and Agent http://support.microsoft.com/?kbid=269074 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Federico Haedo" <fhaedo (AT) harriague (DOT) com.ar> wrote in message news:e8DJZIXgEHA.3548 (AT) TK2MSFTNGP09 (DOT) phx.gbl... When i'm trying tu execute a DTS package from a job of SQL Agent an error occurre: Does anybody know why it happen? Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 13/08/2004 Time: 17:01:18 User: N/A Computer: KPATOT07 Description: SQL Server Scheduled Job 'SIMDW_Foto_Pedidos_' (0x39EE868A12CCFF4FB2E3B2E565593DA6) - Status: Failed - Invoked on: 2004-08-13 17:01:07 - Message: The job failed. The Job was invoked by User harriague. The last step to run was step 1 (DTS_Foto_Pedido). |
#5
| |||
| |||
|
|
This suggests to me (80040005) that the driver is not loaded on the Server AND/OR the DSN if any is used. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Federico Haedo" <fhaedo (AT) harriague (DOT) com.ar> wrote in message news:ee0ZmLVhEHA.3016 (AT) tk2msftngp13 (DOT) phx.gbl... From the DTS interface there is no Error. But from the Agent, the job gives the next Error: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 2004 (7D4) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 2004 (7D4) Error string: [Extended Systems][Advantage ODBC Driver][ISAM]ISAM error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> escribió en el mensaje news:uZYzJ6dgEHA.1972 (AT) TK2MSFTNGP09 (DOT) phx.gbl... You would need to give us more output fromt he job but in general this helps with DTS and Agent http://support.microsoft.com/?kbid=269074 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Federico Haedo" <fhaedo (AT) harriague (DOT) com.ar> wrote in message news:e8DJZIXgEHA.3548 (AT) TK2MSFTNGP09 (DOT) phx.gbl... When i'm trying tu execute a DTS package from a job of SQL Agent an error occurre: Does anybody know why it happen? Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 13/08/2004 Time: 17:01:18 User: N/A Computer: KPATOT07 Description: SQL Server Scheduled Job 'SIMDW_Foto_Pedidos_' (0x39EE868A12CCFF4FB2E3B2E565593DA6) - Status: Failed - Invoked on: 2004-08-13 17:01:07 - Message: The job failed. The Job was invoked by User harriague. The last step to run was step 1 (DTS_Foto_Pedido). |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.