Let’s say we have this query select * from customer where customerid = ’1′ My question is can we create this “customerid = ’1′” condition as a variable in SSIS and once it becomes a varible then I will extract the conditions for a column in table,
Answer Question | February 17, 2010 9:51 PM
SSIS, SSIS 2005, WHERE condition
In Oracle, I can do: Select * from table where field1 || field2 in (’01XX’,’02YY’,’03ZZ’) ; Where field1 has values of 01,02,03 and field2 has values of XX,YY,ZZ etc Can I do the same thing in SQL Server, or do I need define some derived fields to get the same effect?
Answer Question | December 11, 2009 2:42 PM
SQL Server development, SQL Server tables, WHERE condition