I have text file as source and destination will be sql server.
I have a check a source column satisfied the given condition
ie.,DTSSource("Col005") > 100.If satisfied i have to insert that row
other wise rollback the earlier insertion and skip the further
processing.

Note: Check constraint is not defined in the table

What earlier insertion ?

Are you saying you only want to insert rows where the fifth column value is

Personally I would import the whole file into a staging table and then use
TSQL to do the inserts.


--



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