I wasn't able to solve this problem, but I did find a way around it. I put myself through a crash course in XQuery and figured out how to query the data in this field. Using the query, I was able to build a view which accomplishing the same thing as what my SSIS package would have... actually better since its real-time.