Transcations and DTS Packages

[smada80]

Hi all

I am using MS SQL Server DTS packages called from VB6 code to perform imports of data from text files. The problem I am having is that there are several packaages to perform the imports run one after another, but if one fails I need to whole thing to roll back. I have placed the calls to execute these packages in VB within a transaction but this is not working. If a package fails, that particular package rolls back but the previously executed ones do not!

Can anyone help? This would be much appreciated.

Cheers
Matt
Software Engineer

 

[Glasgow]

Can't you just create a package that calls the other packages - presumably then it would behave as any other package and rollback if any 'sub-package' fails.