How do you use parameters in SSIS lookup functionality

• mikelordi2

  Mr or Mrs. 500

  Points: 596

  More actions

  March 11, 2010 at 6:29 am

  #230758

  Hi 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 refTable

  where [refTable].[ClientCompanyCode] = ? and [refTable].[ClientTreatyNumber] = ? and [refTable].[ClientPlanCode] = ?

• mikelordi2

  Mr or Mrs. 500

  Points: 596

  More actions

  March 11, 2010 at 12:33 pm

  #1132262

  I've figured this out by utilizing the Advanced Tab on the function and modifying the SQL. Thanks!

• Ron Patrick-327855

  SSC Veteran

  Points: 227

  More actions

  August 22, 2012 at 9:03 am

  #1528701

  You might consider sharing the answer!

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  August 14, 2013 at 10:39 am

  #1641488

  So, what is the answer?