March 11, 2010 at 6:29 am
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] = ?
March 11, 2010 at 12:33 pm
I've figured this out by utilizing the Advanced Tab on the function and modifying the SQL. Thanks!
August 22, 2012 at 9:03 am
You might consider sharing the answer!
August 14, 2013 at 10:39 am
So, what is the answer?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply