How to stop data flow SSIS when there is a lookup match output and carry on when No Match Output
Hello ,
I have a SSIS package that imports data from spreadsheet into temp table by checking if the data ( year column ) doesn't exist in destination table then will insert data into table. I would like the package to stop if it finds a matching year in destination table.
what the data flow looks like
Excel Source --> Data Conversion --> Lookup --> OLE DB Destination
Kind regards
I have a SSIS package that imports data from spreadsheet into temp table by checking if the data ( year column ) doesn't exist in destination table then will insert data into table. I would like the package to stop if it finds a matching year in destination table.
what the data flow looks like
Excel Source --> Data Conversion --> Lookup --> OLE DB Destination
Kind regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER