Im currently migrating one if my existing application. In existing app. the error handling is done row by row. Data from text file have to be loaded in sql with...

Thankyou Phil for ur quick response.

To summarize, i have an existing VB application which reads data from text file (million rows) and does lot of business logic using ADO recordsets...

Any solution for this?

Thanks Chris,

I used variables to make it dynamic.

i'm updating one clustered index column. If i do with index it takes time to execute, if i do the same update without index its faster. so due to performance...