I need a solution to an ssis package. i need to know how to pass a value to a SSIS package variable.
the value comes from a sql task that runs a aql scripts that returns an integer value.
i need to then pass this value to the already created variable . from then i use this variable as part of a constraint on a connector with "expression and constraint"
asked Apr 19, 2012 at 10:20 AM in Default
To pass the results of a SQL script to a variable you need to:
Your variable is now available for use wherever you need it.
answered Apr 19, 2012 at 10:47 AM
After a quick search on google I came up with the following article that seems to do what you want:
answered Apr 19, 2012 at 10:43 AM