Solved

DTS Package Steps not executed

Posted on 2004-10-12
8
925 Views
Last Modified: 2013-11-30
Hi I have a DTS package that is scheduled to run on a server every hour. The package got deleted accidently and I created it again from a backup. I fixed all the file pointers and ran the package. The pacakge runs, but only three steps actually get completed. for the rest it just says

"Step '' was not executed".

If I run the steps one by one, they run fine. I started logging the result and was able to get one error which I fixed. But now The log doesn't get any error. but still those steps are not run.

anyone who would know what the problem could be?

here is the log out put:

==================================
The execution of the following DTS Package succeeded:

Package Name: NCC - PCSWebDBUpload
Package Description: (null)
Package ID: {93A96295-F647-447C-868B-45C062F46C6F}
Package Version: {2056B661-A494-4200-8A73-6E0913722074}
Package Execution Lineage: {9F85A803-2D9A-4F25-926A-644522EB6CEB}
Executed On: HOBBIT
Executed By: nortak
Execution Started: 10/12/2004 11:25:49 AM
Execution Completed: 10/12/2004 11:25:49 AM
Total Execution Time: 0.125 seconds

Package Steps execution information:


Step 'DTSStep_DTSActiveScriptTask_1' was not executed

Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' succeeded
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_3' was not executed

Step 'DTSStep_DTSExecuteSQLTask_4' was not executed

Step 'DTSStep_DTSActiveScriptTask_2' was not executed

Step 'DTSStep_DTSExecuteSQLTask_5' was not executed

Step 'DTSStep_DTSDataPumpTask_1' was not executed

Step 'DTSStep_DTSDataPumpTask_2' was not executed

Step 'DTSStep_DTSDataPumpTask_3' was not executed

Step 'DTSStep_DTSDataPumpTask_5' was not executed

Step 'DTSStep_DTSDataPumpTask_6' succeeded
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 29

Step 'DTSStep_DTSDataPumpTask_4' was not executed

Step 'DTSStep_DTSDataPumpTask_7' was not executed

Step 'DTSStep_DTSDataPumpTask_8' was not executed

Step 'DTSStep_DTSDataPumpTask_9' was not executed

Step 'DTSStep_DTSDataPumpTask_10' was not executed

Step 'DTSStep_DTSDataPumpTask_11' was not executed

Step 'DTSStep_DTSDataPumpTask_12' was not executed

Step 'DTSStep_DTSDataPumpTask_13' succeeded
Step Execution Started: 10/12/2004 11:25:49 AM
Step Execution Completed: 10/12/2004 11:25:49 AM
Total Step Execution Time: 0.063 seconds
Progress count in Step: 1
****************************************************************************************************
==================================

0
Comment
Question by:qudoos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 10

Expert Comment

by:Jay Toops
ID: 12288488
Very odd.. .try this
create a new package

open the old package and start copying the steps one at a time into the new package.
and of course re-linking the flow steps.

it may be possible to just delete the flow arrows and re-create them too, give it a try.

Jay
0
 
LVL 1

Author Comment

by:qudoos
ID: 12288906
hmm...I tried creating precedence arrows again but still the same.

I would try creating a new package from scratch, but that would be my last resort cause there is a lot of transformation in the tasks.

thanks.
0
 
LVL 10

Accepted Solution

by:
Jay Toops earned 125 total points
ID: 12289120
go to workflow properties and make sure "disable this step is not checked."

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Expert Comment

by:Jay Toops
ID: 12289141
try this too make a copy of this .. strip out everything except for one of the data pump tasks

and execute it ..
maybee you can make a bunch of little packages out of your big one that will work..

i think that the file you restored is corrupted in some way

data pump tasks are very touchy ..

Jay
0
 
LVL 1

Author Comment

by:qudoos
ID: 12289219
I right click on a selected workflow item i.e. my 'On success' and 'On completion' and check properties. I cannot see a checkbox or something where we can disable the step. Same with my transoformation tasks.

Maybe I am missing where this flag is set, can you specify if I am not looking at the correct place?
0
 
LVL 1

Author Comment

by:qudoos
ID: 12289258
i found the flag under the option tab for workflow properties. no they are not checked to be disabled.
0
 
LVL 1

Author Comment

by:qudoos
ID: 12289574
ok the answer I accepted actually guided me in the right direction.

What happened was that all the workflow was screwed.

When I went to see the workflow properties of a task, I came to know that all other tasks are defined as precedence to it. Hence creating a cycle for all tasks thus none would get executed.

I fixed the workflow precedence and it is working fine now.

thanks a lot for the help.
0
 
LVL 10

Expert Comment

by:Jay Toops
ID: 12289791
Excellent ...

probably a corruption problem ...

Glad you were able to resolve it.

I have seen other similar problems that the package had to be recreated to fix

Jay
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question