Steven Willis (6/28/2013)
manibad (6/28/2013)
If we have any other way to achieve the what I desired please suggest me..What I need in the end is I have to achieve the Proper case functionality Through SSIS only.So please guide me through this.
Would a function that does the conversion work for you? If so, I have a proper case function I've been working on and I'd be happy to let you try it out. I tried it on your examples and it returns the correct results.
Even if the OP can't use it, there may well be other people who stumble across this thread that it might help. I for one would be interested to see what you have.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/