Billing Statement

I want to be able to use that variable on the same package in an expression to validate and move to the next step.
So 2 questions:
how to i set a variable from a sql statement?
how to i use a variable as an expression in a constraint?
Thanks you for your help

I haven’t worked with SSIS myself, but take a look at this and see if it answers your questions: http://msdn.microsoft.com/en-us/library/ms140216.aspx

Posted select statement |