which data flow transformation should i use for condition checking and fetching part of data

Question

which data flow transformation should i use for condition checking and fetching part of data

hemanth T

SSC Eights!

Points: 807
More actions
June 13, 2012 at 5:27 am

#147158

Hey everyone,
I am in a situation to
find a character in a varchar column data and if it exists i need to fetch some part of data else i need to fetch other format of data.
in ssis which data flow transformation can i use??
character map
derived column
ole db command......etc.,
I m using ssis 2008
Anyone can help me!!
Thanks:-)

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

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

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

When you say fetch other data, I'm assuming it's not just part of the same field (or columns from that table/view), but rather you need to pull in data from some other spreadsheet, database, ...

If that is the case, then you may want to look at the Conditional Split transformation. This allows you to branch off on another path when your condition occurs (data exists), where you could get the data and then later merge back together with your other path.

Why not just bring all of the data in our original dataflow source? Can you just join the second (may not be possible if in separate Excel sheets, for example) table in your original SELECT? Then only refer to the additional column when your condition occurs (using a Derived Column).

I hope this gives you some ideas.

Rob

hemanth T SSC Eights! Points: 807 More actions · Answer 2

Hey Rob,

I will give detailed picture to you.

i have a column in a table .

i need validate that data by conditions and get the same data formatted.

its like 'abcd@' --original column data.

'abcd' --------derived or required data

Now

Can u help me which transformation should i use with this..

Thanks for reply.

herladygeekedness SSCertifiable Points: 5878 More actions · Answer 3

You said it yourself: Derived, use the Derived Column component.

Using expression syntax you can check the data of any field for existence of certain conditions. If found, you can either change the data in the existing column or create a new one.

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 4

hemanth T (6/13/2012)
its like 'abcd@' --original column data.
'abcd' --------derived or required data

What are you trying to do? Remove all '@' symbols? Remove the last character? Remove the last character only if it is a '@'?

Yes, you can do any of these with the Derived Column Transformation. If you spell out exactly what your condition is, I can help you with the expression.

Rob