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"
i.e. @totalcount > 0 action -> (move on to next task0) @totalcount < 0 action -> (send out an email)
asked Apr 19 '12 at 10:20 AM in Default
To pass the results of a SQL script to a variable you need to:
answered Apr 19 '12 at 10:47 AM
After a quick search on google I came up with the following article that seems to do what you want:
[Pass dynamic parameter values to SQL Server Integration Services]: http://www.mssqltips.com/sqlservertip/1395/pass-dynamic-parameter-values-to-sql-server-integration-services/
answered Apr 19 '12 at 10:43 AM