June 27, 2014 at 12:13 am
Hi there,
I need to integrate the SSIS package in MVC Application. I m very new to SSIS package. I got a requirement that I need to transform the data from CSV to DB table. I have to do validations of complete data(say length should be 10 characters,incorrect string formats,...) from the CSV file. If any one of the record fails validation I have to throw the custom validation message to the user through MVC application(Note: No record should insert into database if even one record fails validation). Please provide a details explanation and if possible a sample application
June 27, 2014 at 12:56 am
June 27, 2014 at 1:27 am
There are couple of ways I can think of, for doing data validations.
1) Approach suggested in http://stackoverflow.com/questions/6464601/how-to-validate-a-csv-file-before-importing-into-the-database-using-ssis link (shared by twin.devil).
2) Temp Table and Validation on it
i) Create a temporary table to insert all the csv data into this. The table should have datatype as Varchar for all the columns, so that because of data type constraint data is not inserted.
ii) Apply all the validations using SQL Script
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply