I am an absolutely beginner to SSIS and need to perform the following task.
- Need to import Master data from (semi colon) ; delaminated flat files into separate tables in SQL Server
- Each file will create a separate table in SQL Server
- While importing I need to perform validation on each file and only extract data that is valid e.g. CNIC column must be numeric and 13 digits long.
- Any data that is not valid will be sent to a separate table with same TableName_bad suffix
- After the data is extracted I will extract the details data of only those records that have been extracted in master table before
I know about basic data flow controls etc but I don’t know which control will be better for which task. Please tell me what will be the procedure to fulfill my requirements. I will be extremely thankful.
Syed Afraz Ali
View Complete Post