• 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.