Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help --Data flow script transformation component / T-SQL / CLR Function ???? Expand / Collapse
Author
Message
Posted Thursday, September 13, 2012 1:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 24, 2014 10:10 PM
Points: 18, Visits: 109
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
Posted Thursday, September 13, 2012 2:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
WTF?

I think this is way beyond my understanding....
Post #1358381
Posted Thursday, September 13, 2012 9:06 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:52 PM
Points: 504, Visits: 1,870
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
Posted Thursday, September 13, 2012 9:18 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:50 PM
Points: 20,730, Visits: 32,490
Hate to say it, but I have no idea what is being asked here either.



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 »

Add to briefcase

Permissions Expand / Collapse