I have inherited several DTS packages that fast-load text files into Sql
Server tables. When such steps run, EM indicates that Bulk Load" is running.
There was a time when a failed bcp "bulk load" would leave a table in an
unhappy state because it was being minimally-logged. I wonder if DTS uses
this method?

I want to avoid damaging the destination tables and only want to load a file
if it is error-free. Otherwise, rollback all inserts. Like one big
transaction. What settings will force this kind of behavior?

Thanks,

Michael

I do not see a problem with BULK INSERTing data into a table and it failing.
The transaction should be atomic.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


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