asked on 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
Microsoft SQL ServerSSIS
Last Comment
deanmachine333
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks i have added this in the Control Flow.