-
I've previously blogged about the challenges of the new 64-bit ACE Provider that includes the Excel driver, since the 32-bit and 64-bit versions cannot be installed side-by-side. In this detailed post that includes screen shots, Hrvoje Piasevoli from Croatia describes 2 approaches for working with...
-
Yesterday (6/7/2010), Ivan Peev of Cozyroc announced the beta release of version 1.5 of SSIS+, Cozyroc's suite of custom components for SQL Server Integration Services . The new components for Excel in SSIS caught my attention. The announcement summarizes this new release as follows: " The new...
-
<tap><tap> Is this thing on? If you've been curious to test the 64-bit version of the provider and driver for Excel, you can download it from: http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en You specify "Excel 14.0"...
-
When we talk about using import mode, "IMEX=1," to resolve a common problem when importing from Excel, we sometimes give or get the impression that setting IMEX=1 automatically imports all data as text. This is an over-simplification. In fact, IMEX=1 causes the value of the Registry setting...
-
First, the good news... If you use SQL Server Integration Services to load data to or from Excel files or Access databases, then a 64-bit driver is headed your way. This is great news for SSIS users in a 64-bit world. Soon you'll be able to run your packages in 64-bit mode on 64-bit computers, rather...
-
CORRECTED ON 4/2/09 FROM ORIGINAL POSTING ON 3/31/09 The Office 12 ACE Provider recognizes the .XLSM extension for a macro-enabled Excel 2007 workbook. However, the Excel Connection Manager (in SQL Server 2008 Integration Services) only recognizes the .XLSX file extension for Excel 2007 files. Therefore...
-
The default Microsoft Excel 2007 file fomat, with the file extension .xslx , is in fact an XML file, or rather a Zip file that contains multiple XML files. However you can also save an Excel file in binary format, with the file extension .xlsb . For more information on Excel file formats, see File formats...
-
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...