none
How to assign any column value coming from source to variable in data flow task in ssis

    Question

  • Hi,

    I am calculating one column in derived column in DTF and then I want to use that column in variable as I want to use that value in my next data flow task.

    Can you please tell me how can I do that?

    I tired one method using script component as transformation is DFT.

    In that, in readwritevariable, I gave one datetime user variable  MAX_PBPS_EFFECTIVE_DT

    and in I/p and O/p, I used that field 'MAX(MEP_EEFF_DT) '

    and in edit script, I wrote below script

    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
            '
             Variables.MAXPBPSEFFECTIVEDT = Row.MAXMEPEEFFDT
            '
        End Sub

    But when I ran the package it gave me error that no row assign to variable.

    Please help me soon. Thanks in advance.




    Vicky

    Wednesday, November 20, 2013 4:04 PM

Answers