Post reply

Need Help --Data flow script transformation component / T-SQL / CLR Function ????

  • September 13, 2012 at 1:05 am

    #393170

    Hi,

    I need a help in SSIS to choose Data flow script transformation component / T-SQL / CLR Function to solve below problem.

    I have a sample table like below:

    TABLE - A :

    SourceAttribute:A.B(1).C(2).D

    Identifier: X.Y.Z

    Index : A.B(1).C(2)

    If the value of X.Y.Z = Q ,then in Table-B, i have to generate DisplayName like below

    For Attribute : A.B(1).C(2).D

    Expected output is Display name: Q_2_D

    In DisplayName column Q_2_D --> Q is value of identifier

    --> 2 is the last number in Index column

    --> D is leftover attribute ( from Index)

    Please help me..

    Thanks,

    santosh kumar.

  • September 13, 2012 at 2:07 am

    #1537052

    WTF?

    I think this is way beyond my understanding....;-)

  • September 13, 2012 at 9:06 am

    #1537274

    Your description is very abstract. It's not clear what you're trying to have SSIS accomplish. You're more likely to be successful in getting help if you follow the suggestions in the following article.

    How to post data/code on a forum to get the best help

    [/url]

  • September 13, 2012 at 9:18 am

    #1537283

    Hate to say it, but I have no idea what is being asked here either.

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

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