Recently an internal Microsoft team ran into performance issues when they switched from using the Jet Provider and writing out Excel 2003 files, to using the Office 12/2007 ACE Provider and writing out Excel 2007 files from their Integration Services package. Their inquiries brought the following information...
In my third installment on Excel issues , I proposed writing out Excel XML rather than binary Excel files as one way to avoid both the issues of the Excel driver, and the risks of Excel automation. Recently I came across a DTS custom task that I wrote in Visual Basic.NET in 2004 that does exactly that...
This post is the 3rd and last in a series of 3 planned installments about using Excel data files with Microsoft SQL Server Integration Services. Connections and components Tables and data types Issues and alternatives Introduction Don't expect miracles . If you've been following this series,...
This post is the 2nd in a series of 3 planned installments about using Excel data files with Microsoft SQL Server Integration Services. Connections and components Tables and data types Issues and alternatives Tables What's a table in Excel? The source of data in an Excel workbook can be: A worksheet...
This post is the 1st in a series of 3 planned installments about using Excel data files with Microsoft SQL Server Integration Services. Connections and components Tables and data types Issues and alternatives The Excel Driver Excel connectivity in SQL Server Integration Services uses the Jet provider...