passing parameters to lookup task


  • Hi I've the following lookup query in the DTS data driven query task 

    SELECT     SUBSTRING(vchParameterDesc, 1, 1) AS Rank
    FROM         dbo.ReferenceParameters WITH (NOLOCK)
    WHERE     (iParameterId = ?)

    I'm upgrading the dts package having the above lookup query in the lookup tab of the data driven query task.

    How can i configure that in the SSIS?
    Friday, September 19, 2008 5:46 PM

All replies