InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 21:08:39 GMT20http://www.sqlservercentral.com/Forums/Topic880934-361-1.aspxYou might consider sharing the answer!Wed, 22 Aug 2012 09:03:51 GMTRon Patrick-327855http://www.sqlservercentral.com/Forums/Topic880934-361-1.aspxI've figured this out by utilizing the Advanced Tab on the function and modifying the SQL. Thanks!Thu, 11 Mar 2010 12:33:30 GMTmikelordi2http://www.sqlservercentral.com/Forums/Topic880934-361-1.aspxHi everybody...I"m new to SSIS, a tool my company is making us use primarily as a DTS tool. What I'm trying to do is use a flat file as the input, perform transformations and pass it to a Sybase table. Where I am stuck is in addition to performing manipulations such as dates, etc, we need to update and add data from a variety of lookup tables. The problem is I need to pass parameters into the lookup as I have a one to many error if I don't.I am trying to take the field "ReinsuranceDate" from the flat file (after converted of course) and using fields "Min_Pol_Dt" and "Max_Pol_Dt" in a lookup table called "PlanCode", add in fields from the "PLaCode" tabel to be mapped, but only where the Reinsurance Date is between the Min_Pol_Dt and Max_pol_dt.I think I am supposed to update the SQL in the advanced tab of the lookup, but I can't figure out how to pass the field I need through. Here is the SQL from the advanced tab as is (I am matching on those three fields)select * from (select * from `PlanCode`) as refTablewhere [refTable].[ClientCompanyCode] = ? and [refTable].[ClientTreatyNumber] = ? and [refTable].[ClientPlanCode] = ?Thu, 11 Mar 2010 06:29:45 GMTmikelordi2