Hi All SSIS 2008 , Oracle ole db provider As I Got ? are nor worked in Oracle Queries? http://consultingblogs.emc.com/jamiethomson/archive/2005/12/09/2480.aspx Yes it works only way to concatenate string either using expressions or script task ? query using ? is better readable - and much easier to correrct say a.ver_cancelled = 'N' and a.ver_start <= ? and ( a.ver_end is null or a.ver_end > ?) in this approach: "a.ver_cancelled = 'N' and a.ver_start <= to_date('" + (DT_WSTR, 20)(@[User::date1]) + "', 'mm/dd/yyyy') and ( a.ver_end is null or a.ver_end > to_date('" + (DT_WSTR, 20)(@[User::date1]) + "' , 'mm/dd/yyyy') ) order by 1" but seems no other way out ?

Use the ADO connection instead. And I think if you'll read this post: http://social.msdn.microsoft.com/Forums/pl-PL/sqlintegrationservices/thread/d5608f8c-333f-4919-ba96-201d4f86b166 you may get a better understanding on the parameter mapping in Oracle.Arthur My Blog

Hi ArthurZ Thanks for answer I tried use ADO: ADO\Oracle Proveider for OLE DB It produces error 1?) What eact do you mean by ADO - there are several choices here 2?) I use for oracle fields with type DATE adDate type in ADO ( really I tried many types DBDATTE , DBTIME) Is it correct ? here eror text: Error: 0xC002F210 at ADO Orcl Param Countries, Execute SQL Task: Executing the query "select nvl (lv.trans , country_desc ) cname from ..." failed with the following error: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Dear Fedor Gullin, You Could try: To set the Oracle OLE DB source component to get the query from a variable. Then in the variable use an expression to build the query reflecting the dynamic values you need. Best regards, Naween