-
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...
-
SQL Server MVP Phil Brammer has already blogged about the fact that, if you have Visual Studio 2008 installed, you have to install VS 2008 Service Pack 1 before installing SQL Server 2008 "Katmai". Why? Because Katmai contains bits and pieces of SP1, and will refuse to install over VS 2008...
-
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 LIMITATION HAS BEEN FIXED AND REMOVED FOR SQL SERVER 2008 RTM. Object of any type can now be passed through package variables of type Object, and consumed within Script task code. No, wait. Maybe it's "My Object doesn't like my Variable." Anyway, we just had to remove one of the...