question

IT1 avatar image
IT1 asked

SSIS BASIC Passing Value

Hi, I have a SSIS package in which I want to execute a data flow only if there is a value that exist for a certain column example CustomerId Address ID 1 1 2 3 2 So I ony want to run the data flow when Customer ID is 1 and 3 and NOT during when its value is 2 as the address Id is null. I knw I can do it by setting a variable but i dont knw how to go abt it Thank You
ssis
10 |1200

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

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
What you mean by > I want to execute a data flow only if > there is a value that exist for a > certain column If you have those values out of the data flow, then you can put a precedence constraint wit expression and evaluate the value stored in variable so that the data flow will be executed only when the variable has particular value (double click the precedence constraint and edit its properties). If you have those data as part of the data flow and you want to save only particular records to the destination, then you can simply filter out the unnecessary data by appropriate condition in the query against source system (if the source allows querying and/or filtering). In case the source is a flat file, or other source where you cannot specify filtering condition, you can simply add a `Condition Split Transformation` into the data flow and redirect the unwanted results to a different output which will not be processed any further and so those unwanted records will filtered out. Only the output with wanted records will be processed further to the destination.
10 |1200

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

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.