Post reply

Unable to insert new records using SSIS script

  • May 7, 2008 at 11:35 am

    #207120

    Hello Friends,

    Here is what i am trying to do

    Input

    Code Instructions

    A Line 1

    A Line 2

    B Line X

    B Line Y

    I want the out put in the format

    First SET

    Line 1

    Line 2

    Second SET

    Line X

    Line Y

    Can i do this using SSIS Script ??

  • May 7, 2008 at 12:23 pm

    #812001

    If you're dealing with a small number of discrete values for the qualifier (the left column on your input), then I would recommend using the Conditional Split transformation. See this link for more information:

    http://technet.microsoft.com/en-us/library/ms137886.aspx

    If your qualifier's distinct values is too large to allow this, you could use a script task but it may be overkill, particularly if you've never used a script in SSIS before. If you can post back some more information about what you're trying to do, I'll be glad to give you some more information.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

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

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