I need to make sure everything in my multi-step package is one big
transaction. I think that I need to check the "Use transactions" package
property, and then flag each step to "join transaction if present." Is that
true? I recently tried that in another package and the package crashed with
something like "no transaction to join." This leaves me uneasy. This should
be cookbook to make work, so if you have any suggestions I would appreciate
hearing them.

Michael

Remember that not everything in your package will be able to join a
transaction. There is an article here about DTS packages and transactions

http://msdn.microsoft.com/library/de...df_tx_0tmb.asp

AND

http://www.databasejournal.com/featu...le.php/3327681


"Snake" wrote: