July 15, 2016 at 4:55 am
hi
i have the following code i was trying to use to pull the data from after the second comma but it errosout.
eg data 1,2,3,4,5,6
what i am tryin to do is ull the 2 from the about sample data. then after that be able to pull the 3 4 5 etc.
any deas where im going wrong
SUBSTRING(CategoryCodeList,FINDSTRING(CategoryCodeList,",",1) - 1,FINDSTRING(CategoryCodeList,",",2) - LEN(CategoryCodeList))
[\code]
July 15, 2016 at 5:41 am
Which version of SSIS are you using?
July 15, 2016 at 6:11 am
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
July 15, 2016 at 6:21 am
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.
July 15, 2016 at 6:35 am
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.
July 15, 2016 at 7:20 am
im using 2008
July 15, 2016 at 7:29 am
ronan.healy (7/15/2016)
im using 2008
you can try either of two option i have mentioned above.
July 15, 2016 at 7:54 am
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.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy