Unanswered: SSIS (SQL SERVER 2008 R2) parse SQL Query result with delimiter
Hi Everyone! First time poster here.
I am very new to everything about SQL, by the way, and this is my first experience with SSIS as well.
I have an SQL query (I am using Query builder in SSIS) which has an output of one string of text per row, each of which has delimiters in it. Specifically, the '|' character. Since I am very new to SSIS I am trill finding my way around - any hints as to how I can parse this string via the delimiter, so that it splits into new rows?
Thanks George - though its not quite what I'm looking for. I am able to parse, but if you pass it a column, then the solutions you directed me to only parse the last row given. Thus I would need wither a "For each row, do this parsing function" or (what I did) was to use the COALESCE function, and made all of my rows into one, then parsed that.
This is probably not the most efficient way it can be done, but this will not be run for many records at all, so efficiency is not our main concern here, just functionality.