question

katerina31 avatar image
katerina31 asked

Create a dynamic solution with SSIS

Hello all, I need to create a process in SSIS that will do the following things per each csv file separately. Each file has a different number of columns and different data types, so I need to come up with a generic solution. So, in a nutshell: 1. Check each file's number of columns and data type. 2. Apply sanity checks to each column. For example, integer should not have (.). 3. As a final outcome, the file will contain all the rows and two additional columns, errorcolumns and errordescription for example: Column1 Column2 Column3 Column4 Column5 Column6 ErrorColumns ErrorDescription 500 800 Test1 Test2 200.8 1/6/2017 80 Test3 Test8 10,2 Column2|Column3|Column4|Column5|Column6 Null|not int|not int|not float|null Could you please help me? Thank you in advance.
sqlssisdata
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.