Hi there,
I have written a DTS package that ends with an ActiveX Script
step to rename the Access database file that the package imports from.
Executing each step works fine but when I run the whole package, the final
step fails, presumably because the Access database is still open. Is there
a was to reference the connections in the script so that I can disconnect it
first?

Regards,

Waldy.

In the workflow properties of the DataPump task you can "Close
Connection on completion"



"Waldy" <waldy (AT) notmail (DOT) com> wrote

O.K. Thanks for that. I have four datapump tasks though, how do I know
which one will be executed last?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

What connection does the Close Connection on Completion close? Source,
destination or both?

You can control the flow of data pump tasks within DTS using workflow
properties. There you can specify what data pump goes first, second, third,
and so on. This way you can control what task fires last, and be sure the
connection is closed once complete.

"Waldy" <waldy (AT) notmail (DOT) com> wrote

You control the flow using precedence constraints

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



"Waldy" <waldy (AT) notmail (DOT) com> wrote

"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote

Hi Simon,
I cant find where you do this. Can you point me in the
right direction?

Thanks.

So I assume you have 2 connection objects, and between those 2 connection
objects you have 4 data transformation tasks. Right click on the first
transformation task and click on "Workflow Properties". This brings up the
workflow properties dialog box. This is where you specify the execution
sequence.
You should only have 1 entry in there now for "Source Step, Presedence,
Desitination Step".
Click the add button at the bottom, and add the next source step (your
second data transformation task), assign the presedence - I assume you want
"Success", then assign the destination. Do this for the other 2 as well,
and if you have defined them properly, the data pump task will execute in
that order.

Does that make sense?


--
Simon Worth


"Waldy" <waldy (AT) notmail (DOT) com> wrote