I have a question relating to the variables in SSIS.
I have an existing etl package with data flow components. One of the column is System_id to identify the Source System, the package is pulling the data from. I plan to create a component which will validate the data based on the Rules stored in the
database. These rules will be accessed based on the System_id + Target combination which needs to be set by the user at design time when the component is dropped.
In design time, i want to access this System_id field for the Custom data flow component so that i can access the database table and display the available Targets for this System_id which the user can set so that i can run the rules against this data.
I understand that i cannot access the value of the data flow at design time. My question is there other way, where i can set the variable value and access it at design time ?
Please let me know
View Complete Post