Hi All,

My DTS Package was working fine. I need to add 4 new task into DTS.
These new 4 task suppose to run first. So I added new task and setup work
flow properties.

here is my problem
Before changing DTS
On Sucess on Sucess
Truncate table -----------------> CopyFile --------------> Upload data etc
....many other Task. Working absolute fine!

After changing DTS
Sucess
Sucess Sucess
4 New task add ---------------> Truncate table ----------------->
CopyFile --------------> Upload data etc ...many other Task.

When I ran my DTS, its only execute newly added 4 task and all other
existing task Not Ran. "I see task status as Not Run" How can I fixed this
problem ? any help . Thx

Kris

It is difficult to see exactly the workflow wmployed here but it is my guess
you are getting stuck on workflow and the LOGICAL OR.

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote

Thanks for reply.Here is the case ..

On Sucess on Sucess
In above case I have added new task name called "Truncate table". Before
adding new task my DTS has only 2 task "CopyFile and Upload data".

Now When I execute DTS, It only execute one task " Truncate table " and rest
all other task not running at all. Even I delete New added task " Truncate
table " and try to run DTS, none of the task is excuted. I see status as task
not ran. I am facing this problem after adding new task "Truncate table ".

Any idea ? Thx

"Allan Mitchell" wrote:

So you have

ExecuteSQL task --> On Success --> COPY a file from A - B --> On Success -->
Transform Data Task

In your case ONLY the ExecuteSQL task happens

Can you check in the Workflow properties of the COPY and make sure that
"Disable" is not checked

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote