where clause condtion as a variable (SSIS 2005)
  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

composite WHERE condition in SQL Server
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