Below is a portion of a text file that I am trying to import to a SQL table from a comma delimited file. I have two questions:
1) How do I get rid of the all of the text that prefixes each data value? For example how do I strip off the 'cat=' and the 'cat_desc' when I import?
2) How can I import the second column as a single column, instead of having SSIS break the field at each comma embedded in the string?
cat=34,cat_desc="Desc06, Desc03, Desc10",hostname=www.somehost.com
Thanks for your help!