> "I would be especially interested to know how Microsoft shops are using the product and how it helps their respective organizations."

We use SSIS as a main data-document interchange platform for our retails software solution. SSIS is a solid brick-building simple to use fast and reliable tool. When integration, we concentrate on substance, not form (it's there, ready to use) and this brings us competitive edge in development speed.