February 12, 2011 at 1:05 am
so i have three names that i need to alter. the rules are all names must have the first letter capitalized. any secondary names must have the first letter capitalized. all middle name initials must be capitalized.
example:
JAMES, marry ann b, or timothy b
they need to look like this:
James, Marry Ann B, or Timothy B
i can do this if i write some t-sql and alter the data after it has been loaded into a table but i need to do this with in the data flow of a package. is this even possible in the Derived Column Transformation? if so can you point me in the right path so i can figure this out?
please help
thank you
wayne
February 16, 2011 at 11:43 am
update:
i just wanted to state that i read a lot of forum posts and articles and the one thing that the "Experts" say is that the derived column is powerful. My opinion is that all you "experts" are full of donkey poo! sure the transformation can use functions to do string manipulation or calculations but when it comes to string manipulation on multiple locations within the string.....well this is something that the derived transformation cannot do. of course you can do what i wanted to a string but you will be using multiple derived columns. i went from using 2 derived columns to 6 and i had to add a conditional split, multicast, and a 2 union as transformations. i have realized that i can write a T-SQL script to alter the data within the control flow and it runs way faster plus i am using only one extra transformation instead of 10 extra transformations. you would have figured that from 2005 through 2010 that Microsoft would have created or added something to at least have to the ability to do this right? as for all you experts out there that have their own websites or web pages...stop copying from Microsoft. you guys use their definitions word for word literally! how about using you minds and experience to quote or talk about the objects or functions within SQL Server. Example: i wanted to find out about the "Linguistic Function" with in the character map transformation and i found 20+ different webpages that quote the definition from Microsoft but nobody used their own words to help breakdown the vague definition from Microsoft. If i was bill gates i would sue every one of you just cause they could not use their minds. Damn Plagerists!
< Calm Breathing> <Calm Breathing> <Calm Breating>
sorry for that i meant to just give an update to my post but it turned into a venting session. i appologise. 🙂
wayne
February 16, 2011 at 1:52 pm
The derived column definitely looks like it can't do what you want, however a Script transformation would probably handle that easily (with an additional function written to handle to specifics).
Steve.
February 16, 2011 at 4:44 pm
yes steve you are right. a script component can do the job but you would be up the creek if you do not know VB as in this case i do not know VB enough to write the code yet. 🙁 give me a week to get the basics and then i will be scripting a lot. 🙂
by the way steve.....thanks for the response 🙂
wayne
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply