Last post Jun 08, 2015 05:16 AM by wmec
Jun 03, 2015 08:07 PM|Alexyang6868|LINK
I have several records(dynamic) from one query in SSIS. a task which is , check 3 records(1.2.3) based on a condition from those records . if 2 of 3 records are valid, then remove first one(1) , add another one, then check another 3 recordes(2,3,4) , if
2 of 3 records are vaild , the remove first one(2), the check another 3 (3,4,5).
if 2 of 3 records are invaild. delete those 3 reords. then get another 3 records (6.7. 8) to continue.
how can do this in SSIS?
Jun 07, 2015 10:22 PM|Edwin Guru Singh|LINK
According to this case, you can try to do by Data Flow task in SSIS.
1. Need to specify the source & destination table
2.Load the data from source table (As per requirement, select top 3 records)
3.you can get the data from destination table
4.Compare the values with the help of sub query
5.based on the condition ,you need to assign update or delete operation.for that you can use "Lookup Transformation Editor"
for more information,
Click here refer the above steps in details.
Jun 08, 2015 05:16 AM|wmec|LINK
You need to validate the records using SqlCommand.