Post reply

Data driven query task equivalent in SSIS

  • October 1, 2008 at 8:04 am

    #879487

    Hi in the ActiveX script component the script is as follows

    arr = Split(DTSSource("vchContactKey"),"~",3)

    DTSGlobalVariables("WINCoCd").value =arr(0)

    DTSDestination("CNTCT_SEQ_NUM) = arr(1) & arr(2)

    Then in the derived column task of SSIS the derived column function will be

    arr_0 = SUBSTRING("vchContactKey",0,3)

    arr_1= SUBSTRING("vchContactKey",1,3)

    arr_2= SUBSTRING("vchContactKey",2,3)

    Am i thinking in the correct way or not?

    Thankx in advance

  • October 1, 2008 at 8:10 am

    #879491

    substring is not the same as split, but that is a function you would need to use.

  • October 1, 2008 at 8:17 am

    #879495

    arr = Split(DTSSource("vchContactKey"),"~",3)

    DTSGlobalVariables("WINCoCd").value =arr(0)

    DTSDestination("CNTCT_SEQ_NUM) = arr(1) & arr(2)

    Then in the derived column task of SSIS the derived column function will be

    arr_0 = SUBSTRING("vchContactKey",0,3)

    arr_1= SUBSTRING("vchContactKey",1,3)

    arr_2= SUBSTRING("vchContactKey",2,3)

    So now can i go ahead and use the above substring functions in the derived column task for split?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply