Post reply

activex script transformation in ssis

  • September 22, 2008 at 12:27 pm

    #127543

    Hi .....i've one doubt regarding DTS/SSIS... I'm migrating DTS packages to SSIS..in one of the DTS packages data driven query task is used in which while transforming data from source to binding tables ActivesX transformation mapping is used. Now my issues is how can I do mapping using ActiveX script transformation in SSIS. i.e which task can i use to map tables using activex script transformation. Can u help me out in this issue

  • September 23, 2008 at 1:36 am

    #875457

    Is this activex script task issue not related to your lookup issue.

    If so, please dont cross post

  • September 23, 2008 at 5:34 am

    #875563

    Use script task before any DFT and save the query inside the script into a variable, which needs to be declared in the variable section. Next use that variable inside the DFT.

    I dont know this, whether you posted for this problem or not. But this is what I felt from your post.

    Thnx.

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

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