Validating the CSV data before inserting into SQL Server

Question

I have a senario where i have to check the first column of the excel has a valid data and not in the other columns from the CSV file. If the data is not present in the first column my SSIS package should log an exeption.

Can any one help me in this senario please.

Thanks, Sateesh.

My FOSS tool csvfix at code.google.com/p/csvfix does CSV validation, among other things. — user2100815
– user2100815, Commented May 24, 2011 at 13:36

HLGEM · Accepted Answer · 2011-05-24 18:43:22Z

2

In SSIS you can use a conditional Split task to do this and send the good data to where you want it and the bad data to an exception table.

Personally I always prefer to start with putting the data for any import into two tables, one with the raw unchanged data and one that will contain the cleaned up data before the import to the prod tables. This makes it easier to see what the cause is when you inevitably have to research why some bad data got into the database (if you are doing your job right, 90+% of the time it's bad data you were sent _ you can't know the contract expires on 4/12/2012 when you were sent 4/12/2011 to pick a not so random example). Also always make sure to save the input file to an archive loaction. Trust me, you will need one or more of those archived files some day.

answered May 24, 2011 at 18:43

HLGEM

97k15 gold badges120 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Validating the CSV data before inserting into SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related