Error code 8004043B - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Error code 8004043B

Author

Topic

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 2006-12-22 : 04:20:22

Hi all,

I'm new to DTS and a series of our jobs have
failing since the (logical) FTP server on which they depend (I don't know how the data flows, no docu) was moved to another city. I already changed the FTP IP property in Global Variables to the new server, and connectivity checks out ok. The only clue I have is an explicit failure below in bold.

Only problem is, the message "Step 'DTSStep_DTSActiveScriptTask_15'" doesn't make explicit where I can find "Task_15"?!?!?!?

Any idea how to faultfind this?? Here's the whole message...

The execution of the following DTS Package succeeded:

Package Name: CIVICA_TRANSFER_BALANCE_FROM_CIVICA_TO_CAPITA_LIVE
Package Description: Civica Development
Package ID: {A76927AB-0D5B-43CB-8C75-84848DECFB69}
Package Version: {333B96D0-6A99-4078-9641-07127639C43C}
Package Execution Lineage: {92322DAB-8BF7-4F51-B3AB-9089728F3C67}
Executed On: LBBSVS02
Executed By: sqladmin
Execution Started: 22/12/2006 00:00:15
Execution Completed: 22/12/2006 00:01:16
Total Execution Time: 61.578 seconds

Package Steps execution information:

Step 'DTSStep_DTSActiveScriptTask_4' was not executed

Step 'DTSStep_DTSActiveScriptTask_9' succeeded
Step Execution Started: 22/12/2006 00:00:46
Step Execution Completed: 22/12/2006 00:00:46
Total Step Execution Time: 0.25 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_13' succeeded
Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.047 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_14' succeeded
Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_16' succeeded
Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.032 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 22/12/2006 00:00:15
Step Execution Completed: 22/12/2006 00:00:15
Total Step Execution Time: 0.515 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_1' succeeded
Step Execution Started: 22/12/2006 00:00:15
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.5 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_2' was not executed

Step 'DTSStep_DTSActiveScriptTask_3' succeeded
Step Execution Started: 22/12/2006 00:00:46
Step Execution Completed: 22/12/2006 00:00:46
Total Step Execution Time: 0.047 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded
Step Execution Started: 22/12/2006 00:00:46
Step Execution Completed: 22/12/2006 00:00:46
Total Step Execution Time: 0 seconds
Progress count in Step: 0

Step 'DTSStep_DTSCreateProcessTask_1' succeeded
Step Execution Started: 22/12/2006 00:00:56
Step Execution Completed: 22/12/2006 00:01:06
Total Step Execution Time: 9.938 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_5' was not executed

Step 'DTSStep_DTSActiveScriptTask_6' was not executed

Step 'DTSStep_DTSActiveScriptTask_8' was not executed

Step 'DTSStep_DTSActiveScriptTask_10' was not executed

Step 'DTSStep_DTSActiveScriptTask_7' succeeded
Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.078 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_11' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' succeeded
Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:46
Total Step Execution Time: 30 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_12' succeeded
Step Execution Started: 22/12/2006 00:01:16
Step Execution Completed: 22/12/2006 00:01:16
Total Step Execution Time: 0.063 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_3' succeeded
Step Execution Started: 22/12/2006 00:01:06
Step Execution Completed: 22/12/2006 00:01:16
Total Step Execution Time: 10.015 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_4' was not executed

Step 'DTSStep_DTSExecuteSQLTask_5' succeeded
Step Execution Started: 22/12/2006 00:00:46
Step Execution Completed: 22/12/2006 00:00:56
Total Step Execution Time: 10.015 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_15' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution.
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_17' was not executed

Step 'DTSStep_DTSActiveScriptTask_18' was not executed

Step 'DTSStep_DTSActiveScriptTask_19' was not executed

Step 'DTSStep_DTSExecuteSQLTask_8' was not executed

Step 'DTSStep_DTSActiveScriptTask_20' was not executed

Step 'DTSStep_DTSExecuteSQLTask_9' was not executed

Step 'DTSStep_DTSActiveScriptTask_21' was not executed

Step 'DTSStep_DTSActiveScriptTask_24' succeeded
Step Execution Started: 22/12/2006 00:00:16
Step Execution Completed: 22/12/2006 00:00:16
Total Step Execution Time: 0.015 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDynamicPropertiesTask_3' was not executed

Step 'DTSStep_DTSCreateProcessTask_2' was not executed

Step 'DTSStep_DTSExecuteSQLTask_6' was not executed

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-22 : 04:38:20

Are you importing a column as INT, when there are more than 9 digits?

Peter Larsson
Helsingborg, Sweden