Thank you so much for everyone's suggestions.

Seems like Bulk Import would work. I tired it, but it says I don't have permission to do a bulk import. The...

I have to import data from an excel file. First...

Lalitha,

I find it easier to first load the whole file (in yoru case, CSV file) into the table and then check for data validation. You can use a simple...

Hi,

I do this all day. I don't know what's your knowledge level on SSIS, so I would assume it's basic.

use data flow task in SSIS. Under "Data Flow"...

Michael,

Thanks. But I tried this and it worked.

CASE

WHEN [LastBill]='FINAL BILLED' AND (CURRINSBAL1 > CURRINSBAL2) AND (CURRINSBAL1 > CURRINSBAL3) AND (CURRINSBAL1 > PATBALANCE)THEN CURRINS1

WHEN [LastBill]='FINAL BILLED' AND (CURRINSBAL2 >...

Thanks. It helped.