Steve Jones - SSC Editor (3/19/2013)

---

Did you look at the link?

The second article talks about imports: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72493/

When you do the import, you'll need to then separate out the various parts of the data. This isn't a simple quick thing to answer. What is probably easiest for you is to use the Import Wizard and import to a staging table. Then use T-SQL to separate out the rows.

http://msdn.microsoft.com/en-us/library/ms140052.aspx