Advertisement

04.03.2008 at 01:48PM PDT, ID: 23294179
[x]
Attachment Details

SQL DTS Package works but Job fails when executing the package

Asked by Wedmore in MS SQL Server

Tags: , ,

I created a DTS package which pulled data from an ODBC source and put the data into a SQL table.  All transformations are correct.  I execute the package manually and it works perfectly.

In Local Packages, I right click and choose "Schedule Package" putting in the schedule (2am).  As a test, I went to the Job that was created and ran it by choosing "Start Job".  It fails with the following error:

Any ideas why?  I didnt think there is a difference between executing a package manually and then as part of a job.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

Executed as user: DB3\SYSTEM. DTSRun:  Loading...   DTSRun:  Executing...   
DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1   
DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   
DTSRun OnError:  DTSStep_DTSDataPumpTask_1, 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_DTSDataPumpTask_1   
DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.
 
Keywords: SQL DTS Package works but Job fails …
Title
1 SQL DTS Data Transformation - text t…
2 DTS Expert
3 Saving DTS Packages
4 DTS without Enterprise Manager
5 DTS
6 SOAP and DTS? How to schedule we…
 
Loading Advertisement...
 
[+][-]04.03.2008 at 01:53PM PDT, ID: 21276864

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.03.2008 at 01:55PM PDT, ID: 21276873

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.03.2008 at 01:58PM PDT, ID: 21276899

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.03.2008 at 02:01PM PDT, ID: 21276922

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: Microsoft, SQL, 2000
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 2
Solution Grade: A
 
 
[+][-]04.03.2008 at 02:01PM PDT, ID: 21276927

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.03.2008 at 02:03PM PDT, ID: 21276946

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628