January 10, 2008 at 12:30 am
Sorry for the long description I am posting.
I have a DTS package with 6 data pump tasks each writing to one file corresponding to a year (2002_extract.txt ..... 2007_extract.txt).
I run the package as scheduled job using DTSRun. It pulls one or two years and then exits out. Below is the "Job History" and "Error Log".
Job history:
----------------------------------------------------------------
Executed as user: AD-ENT\1WFF999999Essbase. ...TSStep_DTSDataPumpTask_6 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 7000 Rows have been transformed or copied.; Perc... Process Exit Code 1. The step failed.
------------------------------------------------------------------
Error Log:------------------------------------------------------------------
Step 'DTSStep_DTSDataPumpTask_5' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
Step Execution Started: 1/8/2008 9:59:45 AM
Step Execution Completed: 1/8/2008 10:12:20 AM
Total Step Execution Time: 755.875 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPumpTask_6' succeeded
Step Execution Started: 1/8/2008 9:56:41 AM
Step Execution Completed: 1/8/2008 9:59:45 AM
Total Step Execution Time: 183.344 seconds
Progress count in Step: 487617
-----------------------------------------------------------------
I would really appreciate if somebody can help me with the issue.
Thanks in advance,
CoolHusker.
January 10, 2008 at 11:10 am
Does the DTS package always fail on the same transformation?
Are all of the source files on the same server?
Are they all imported into the same SQL server?
You could try using the FileSystemObject in an Active X Script task to copy the source files to your SQL server then execute the transformations on the local files.
You should also verify that any anti-virus software you're running isn't blocking the communication.
January 10, 2008 at 11:46 am
The error log said Step 'DTSStep_DTSDataPumpTask_5' failed not Step 'DTSStep_DTSDataPumpTask_6' and it failed due to network problem.
January 10, 2008 at 1:40 pm
Thanks for the reponse.
Erik Kutzler (1/10/2008)
Does the DTS package always fail on the same transformation?It fails at one of the pump tasks.
Are all of the source files on the same server?
Its a select from star schema and it writes to files and not imports/
Are they all imported into the same SQL server?
Files are written on the same server.
You could try using the FileSystemObject in an Active X Script task to copy the source files to your SQL server then execute the transformations on the local files.
You should also verify that any anti-virus software you're running isn't blocking the communication.
January 10, 2008 at 1:44 pm
Loner (1/10/2008)
The error log said Step 'DTSStep_DTSDataPumpTask_5' failed not Step 'DTSStep_DTSDataPumpTask_6' and it failed due to network problem.
Since I am writing to files on the server itself, I would assume its not a network problem.
Is there a way to get more debugging information on this by setting some parameter. "Exit code 1" is too generic. Please let me know.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply