SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Error code 8004043B
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 12/22/2006 :  04:20:22  Show Profile  Reply with Quote
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

Sweden
30115 Posts

Posted - 12/22/2006 :  04:38:20  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Are you importing a column as INT, when there are more than 9 digits?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 12/22/2006 :  07:39:48  Show Profile  Reply with Quote
quote:
Originally posted by Peso

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


Peter Larsson
Helsingborg, Sweden



Don't know, and this close to Christmas, I'm calling it a wrap.

:)

Merry Christams all of you!!

:)


JB
Go to Top of Page

readysetstop
Posting Yak Master

USA
123 Posts

Posted - 12/22/2006 :  08:17:41  Show Profile  Visit readysetstop's Homepage  Send readysetstop a Yahoo! Message  Reply with Quote
If you go into Disconnected Edit... in the DTS designer, you can look up what step 15 is in there.
Go to Top of Page

ideotaimism
Starting Member

1 Posts

Posted - 03/07/2011 :  11:55:41  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000