Post reply

Script for Lookup component of data driven query task of DTS in script component of ssis

  • September 22, 2008 at 8:40 pm

    #123797

    Hi

    I'm migrating DTS packages to SSIS. In one of the packages there is a lookup query in lookup tab of the data driven query task of DTS package . That lookup tab in the data driven query task has the following lookups 'ReferenceExtra' and 'ReferenceChar'.

    And those lookups are used in the ActiveX script as following

    DTSDestination("vchUser7") = DTSLookups("ReferenceExtra").Execute(67,DTSSource("mr_type")) 'MR Type

    DTSDestination("vchUser8") = DTSLookups("ReferenceChar").Execute(68,DTSSource("dunbrdst")) 'Corp Acct

    How can i write equivalent script in the Script component of SSIS.

    Please help me out.

  • September 23, 2008 at 1:34 am

    #875456

    Yes you can,

    Either use the merge join transform or the lookup transform. Careful though, both these require sort components on both inputs which may slow your package down, depending on the size of the resultset you are looking up

    Good luck!

    ~PD

Viewing 2 posts - 1 through 1 (of 1 total)

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