asked
how to read/validate a excel file and stored into the sql server database through script component in ssis 2012?
i have excel file source, i want to read/validate the file with ssis script task 2012then store into the sql DB. can anyone share step 2 step process so that i can do this.
where have you looked already, what part of the process are you having problems with?
You could create a dataflow with a script task in the middle. Read the data from the spreadsheet, evaluate in the script, and then store in the destination. Alternatively, you could load all of the data into the database and then validate. In most cases, you can dump the sheet into a table of large varchar fields. Then you can process, validate, etc. from there and copy the good data to another table via dataflow task. We have found that to be easier in some cases because we are more familiar with querying and validating table data rather than spreadsheet data.
16 People are following this question.
