manibad (10/13/2013)
Phil Parkin (10/13/2013)
A brief Google search led me to this [/url]article.It's not difficult, but it's much easier (and almost certainly faster) if you can do this in T-SQL instead.
thanks for this.
I wanted to achieve this in SSIS and through google i know we can achieve it in T-SQL.But i my desire is to achieve throught SSIS
That's fine. The link describes how.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.