I have a text file with 300 rows and try to transform into sql server
2000 using DTS. Suppose i got a integrity in 250 rows.
I want to roll back the inserted data.
Can any one give me suggestion.
Expecting ASAP.

If the task fails in the middle then none of the data will be inserted
so long as you have a batch and insert size of 0.

Allan

"guna_selvas (AT) yahoo (DOT) com" <guna_selvas (AT) yahoo (DOT) com> wrote

Thanks.
I have to validate a column in ActiveXScript
If souce value is greater than 100,
ie, DTSSource("Col005") > 100 . Then i have to insert a value
Otherwise rollback eariler insertion and skip the further processing

Note: There is no integrity check defined in a table

See my relpy to your other question about the same thing.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


<guna_selvas (AT) yahoo (DOT) com> wrote