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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Need Help --Data flow script transformation...

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

Rate Topic

Display Mode

Topic Options

Author

Message

ssskumar4u

Posted Thursday, September 13, 2012 1:05 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 10:55 AM
Points: 12, Visits: 62

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.

Post #1358357

Mackers

Posted Thursday, September 13, 2012 2:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 117, Visits: 460

WTF?

I think this is way beyond my understanding.... Wink

Post #1358381

kl25

Posted Thursday, September 13, 2012 9:06 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:23 AM
Points: 243, Visits: 1,103

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

Post #1358640

Lynn Pettis

Posted Thursday, September 13, 2012 9:18 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 21,625, Visits: 27,468

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

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1358651

« Prev Topic | Next Topic »

Permissions