Simple DTS to SSIS conversion?

Discussion in 'microsoft.public.sqlserver.dts' started by robboll, Jun 14, 2010.

  1. robboll

    robboll Guest

    I have a DTS package with Transformations that look like this:

    Function Main()

    DTSDestination("PART_PAY_PAYMENT") = DTSSource("Col030")
    DTSDestination("PART_PAY_TOTAL_DUE") = DTSSource("Col031")
    DTSDestination("PART_PAY_CUMUL_DUE") = DTSSource("Col032")
    'DTSDestination("PART_PAY_REMAINDER_DUE") = DTSSource("Col033")
    if len(trim(DTSSource("Col033"))) > 0 then
    DTSDestination("PART_PAY_REMAINDER_DUE") = DTSSource("Col033")
    else
    DTSDestination("PART_PAY_REMAINDER_DUE") = null
    end if

    DTSDestination("NOT_ON_SYSTEM_COURT_COST") = DTSSource("Col034")
    DTSDestination("LANGUAGE_CODE") = DTSSource("Col039")
    DTSDestination("AGENCY_CODE") = DTSSource("Col040")
    'DTSDestination("CURRENT_COURT_DATE") = DTSSource("Col041")
    If IsDate(DTSSource("Col041")) then
    DTSDestination("CURRENT_COURT_DATE") = DTSSource("Col041")
    else
    DTSDestination("CURRENT_COURT_DATE") = null
    end if

    DTSDestination("VOID_REASON") = DTSSource("Col102")
    DTSDestination("VOID_OPERATOR") = DTSSource("Col103")
    'DTSDestination("VOID_DATE") = DTSSource("Col104")
    If IsDate(DTSSource("Col104")) then
    DTSDestination("VOID_DATE") = DTSSource("Col104")
    else
    DTSDestination("VOID_DATE") = null
    end if

    'DTSDestination("OFFENSE_DATE") = DTSSource("Col105")
    If IsDate(DTSSource("Col105")) then
    DTSDestination("OFFENSE_DATE") = DTSSource("Col105")
    else
    DTSDestination("OFFENSE_DATE") = null
    end if
    DTSDestination("COLLECTION_AGENCY_TAPE_FLAG") = DTSSource("Col106")

    Main = DTSTransformStat_OK
    End Function



    When I first built the DTS package the commented lines failed and had
    to be coded to prevent errors. So the first time I ran the DTS
    package, this line failed:

    'DTSDestination("PART_PAY_REMAINDER_DUE") = DTSSource("Col033")

    And I needed to input this code in order to qualify the data before it
    processed:

    if len(trim(DTSSource("Col033"))) > 0 then
    DTSDestination("PART_PAY_REMAINDER_DUE") = DTSSource("Col033")
    else
    DTSDestination("PART_PAY_REMAINDER_DUE") = null
    end if


    I am having similar problems in an SSIS package. What would the
    script look like in an SSIS package?

    Thanks for any help!

    RBollinger
     
    robboll, Jun 14, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.