Hi folks,

I have a source with some 3,500 columns over around 100 columns. I need to find a way to build Data Conversion tasks in SSIS without manually going through and defining each column.

The XML seems overly complex and the chance of screwing up linage ids pretty high. Is there an add-in or utility I can use to speed up the process?

Thanks in advance.