SSIS & Excel (Part 2)
Monday, March 5th, 2007More 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.