InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:53:36 GMT20http://www.sqlservercentral.com/Forums/Topic938645-148-1.aspxParameters can be passed to the where clause if the entire query is stored in a string variable.If there are 2 parameters to be passed, then create 3 variables.One variable should be -- Sting data type contains the actual query -- Set Evaluate as Expression property to TRUEOther two variables can be of any data type depending on the type of parameter to be passed.See Example below:User::Query = "SELECT * from CLAIMDXwhere ClientID = "+ (DT_WSTR, 10) @[User::clientID]+ " AND InsertDateTime = TO_DATE(' "+ (DT_WSTR, 10) @[User::InsertDate] + " ', 'MM/DD/YYYY')"This example has the query stored in the variable USER::QueryParameters passed are clientID (numeric data type) and InsertDate(Date type).Note that we need TypeCast operators to convert each type to string.Also make use of the "Evaluate Expression" feature to verify that the query created is valid and you should be able to run it in Oracle database.Thu, 17 Jun 2010 12:46:14 GMTvineet_http://www.sqlservercentral.com/Forums/Topic938645-148-1.aspxAnd the question is...?Thu, 17 Jun 2010 06:18:27 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic938645-148-1.aspxI have a OLE DB Source in a package that returns data from an Oracle db to a table in SQL. I want to pass a parameter to the where clause.Wed, 16 Jun 2010 22:32:03 GMTbob_kudulis