How can i create a variable in SSIS that capture information from a Select 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

TheMadProfessor2009-08-26T06:49:08Z

Favorite Answer

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

00

Related Questions

Why does my SELECT statement in SQL work with digits for a variable but not with a string for same variable?Who agrees with this statement?How did god get his information before the google was created?Help with using variable in Oracle SQL select statement?How can I create a device to capture the most sunlight in 5 min.?

Trending Questions

why does my little sister make me download all of these python packages?5 answersWhat are the applications of Python?7 answerscreate a program every sum that shows the sum of 1 to n for every n from 1 to 50?4 answersWhat is the way to access the deep web?5 answersA question for programmers. Is it too late to start programming at age 35, but to get a job not just for fun. ?7 answers