tag:blogger.com,1999:blog-8600927897234142120.post439462588730848236..comments2023-12-23T03:43:29.570-08:00Comments on BI Polar: Splitting a Delimited Column in SSISMatthew Rochehttp://www.blogger.com/profile/17230399970488763978noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8600927897234142120.post-51802111170722608722010-12-22T02:53:55.666-08:002010-12-22T02:53:55.666-08:00So fantastic, but i'm on SQL 2008 Bids and the...So fantastic, but i'm on SQL 2008 Bids and the script don't work.<br /><br />Maybe due to VSTA and C# ?<br /><br />I can't switch to VB in my scipt component editor .<br /><br />RegardsAdministrateurhttps://www.blogger.com/profile/08668172236412725254noreply@blogger.comtag:blogger.com,1999:blog-8600927897234142120.post-28576590961773537192010-03-03T14:03:53.182-08:002010-03-03T14:03:53.182-08:00Still Good! Thank you :)Still Good! Thank you :)Epiktohttps://www.blogger.com/profile/15227378262062030252noreply@blogger.comtag:blogger.com,1999:blog-8600927897234142120.post-32203664825849841032009-08-18T08:47:22.837-07:002009-08-18T08:47:22.837-07:00@Shrek: Yes, you can do this with a single script ...@Shrek: Yes, you can do this with a single script transformation. You'll just need to update the code to parse the row contents differently. I would start by having two string array variables (one for each delimited column) and then instead of using a For Each loop over a single array, use a For loop and address the elements in each array by index number. But the short answer is yes - this should be a relatively simple problem to solve, and the solution approach should be the same.Matthew Rochehttps://www.blogger.com/profile/17230399970488763978noreply@blogger.comtag:blogger.com,1999:blog-8600927897234142120.post-46065809967571340172009-08-05T21:28:48.328-07:002009-08-05T21:28:48.328-07:00Can two delimited columns be split into rows using...Can two delimited columns be split into rows using one script tranformation? <br />Eg:<br />KeyField ListField1 ListField2<br />1 a,b,c A,B,C<br />2 b,c B,C <br />3 b,d,e B,D,E<br />Transformed to:<br />KeyField ListField1 ListField2<br />1 a A<br />1 b B <br />1 c C<br />2 b B<br />2 c C<br />...etcUnknownhttps://www.blogger.com/profile/14202743225096573236noreply@blogger.comtag:blogger.com,1999:blog-8600927897234142120.post-41588337297653272212008-08-25T07:07:00.000-07:002008-08-25T07:07:00.000-07:00Nice. I needed this exact thing. I was not sure ...Nice. I needed this exact thing. I was not sure how to do it, but had an ideas this was how it worked.Anonymoushttps://www.blogger.com/profile/10597545408348167623noreply@blogger.comtag:blogger.com,1999:blog-8600927897234142120.post-4601486883312371852008-07-09T05:21:00.000-07:002008-07-09T05:21:00.000-07:00Too good...!!!Too good...!!!Andy..!!!!https://www.blogger.com/profile/14398650482377013974noreply@blogger.comtag:blogger.com,1999:blog-8600927897234142120.post-37712617195594187702008-06-22T22:37:00.000-07:002008-06-22T22:37:00.000-07:00Cool stuffCool stuffRahul Kumarhttps://www.blogger.com/profile/01539891813340172117noreply@blogger.com