Hi i wanted to stop the execution of package, scenario is that there is some
flag variable which i have to check within package and within transformation
to stop or to continue the package execution like in data transform task i
want to check the flag value after every batch so it can stop the transfer of
data if it is no more required.

Thanx
Manoj Kumar

See if any of these examples will help. They are not specific to your
problem but may give you insight and ideas on how to solve it.

http://www.sqldts.com/default.aspx?103

Hi Ken,
thanx for reply the site you mentioned is very informative but i am still
looking for the solution/help related to my problem any help regarding to
that will be great.

"Manoj Kumar" wrote:

Manoj,

Please post very specific detail to your problem and I will take a look
when I get home.

Thanks

The specific details are that i am working on dts package that will be
executed to load the data from ODS sources and place that data at staging
area corresponding to every package there is job which will execute the dts
package so what my managers wants that while loading if someone notifies that
the data is not fully prepared for load it needs some more processing than
there must be wayout to forcefully stop the execution of package and the
transaction must be rollbacked so that changes will not reflect in staging
area it will save time and efforts.
I was thinking of to implement this in DTS package by utilizing error output
there is variable which have the value continue/block so before
transformation i can check the variable's value if it is block then move to
error handling routine which will raise error and stops the execution of
package but it can only help before the transformation check while
transformation it cann't help so i want some wayout to stop the package
execution at any stage.
May be this requirement could be completed by someother wayout like i was
thinking of to stop the job but i am not sure wether it will stop the
transformation and if stopped the transaction will be rollbacked.

Thanks and Regards
Manoj Kumar




"Ken" wrote: