Archive for the 'Microsoft' Category

Next Entries »

Excel & SSIS (Part 1)

Monday, January 15th, 2007

Came across an irritating behaviour with the Excel source in SSIS. The Excel ODBC Jet Driver that SSIS uses has the annoying default configuration of only checking the first 8 lines in a spreadsheet, to evaluate the field length of any external columns in the Excel source task…

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

(more…)

Posted in Nuggets, SSIS, Fixes, SQL Server 2005 | 4 Comments »

An Unreliable Source

Thursday, December 14th, 2006

I recently had a problem with a new source I was asked to load into the data warehouse. I’m sure its quite familiar to many…

Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset 

(more…)

Posted in Nuggets, SSIS, SQL Server 2005 | No Comments »

Next Entries »