twin.devil (7/15/2016)
Phil Parkin (7/15/2016)
twin.devil (7/15/2016)
If you want to do it in SQL SERVER then Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]If you want to do in SSIS then check the following The Script Component as a Transformation
Unless it's SSIS 2012 or higher, in which case TOKEN takes care of it without any need for scripting ... assuming that the number of elements is constant, that is.
+1 Phil you are right only If OP is using SSIS2012, I have replied because question posted in SSIS 2005 section.
You were right to do so. But as there are only two SSIS forums here on SSC (2005 and 'the rest'), people sometimes post in the wrong one.
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.