ERROR IN EXECUTION OF A DTS SHEDULED JOB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ERROR IN EXECUTION OF A DTS SHEDULED JOB

hai friend.. i am using SQL SERVER 2000 and enterprise manager for creation DTS package… i created the DTS package from my local machine and it runs manually.. and then i sheduled the package to run automatically at a specific time..but it wont work… and i got an error like this…
DTSRun: Loading…
DTSRun: Executing…
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_24
DTSRun OnError: DTSStep_DTSExecuteSQLTask_24, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_24
DTSRun: Package execution complete.
please give a solution to recover from this from sandeep
Schedule job has sa permissions?
Luis Martin
Moderator
SQL-Server-Performance.com
yaa..it has sa permission and password
Sandeep:
Check if you have rights or priveleges to launch the DTS task. This is not common amongst environments configured as multi-homed. Also, is this job extracting or exporting data off another server?
Amit Shah
Web Developer
Civic Resource Group

Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;238367 and see whether applies to your situation. And refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule a DTS package. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>