Archive for March, 2007

SSIS & Excel (Part 2)

Monday, March 5th, 2007

More Excel woes with SSIS…

Be very careful when using Excel as your transformation destination. Given that it is hard to maintain a consistent controlled version of any excel file you are using, it can be very prone to fail on account of the encoding that is used within it.

Excel 2003 Power Programming with VBA

(more…)