-
My hard-working teammate and fellow technical writer, Carla Sabotta , recently scanned the records of an eye-crossing 900 Microsoft Support incidents involving SQL Server Integration Services 2005 and 2008. She was looking for issues that the customer could easily have answered with nothing more than...
-
Here are the top Microsoft Support Knowledge Base articles that SQL Server Data Transformation Services (DTS) customers have been reading. You may find them useful also. This time I've simply sorted the list from most viewed to least view, for the cumulative timeframe of FY06 through the incomplete...
-
Here are the top Microsoft Support Knowledge Base articles that Integration Services customers have been reading. You may find them useful also. The numeric columns in the following table represent rank in the indicated period by number of page views: "1" means that KB article got the most...
-
Here are a few suggestions for some of the things that may be tripping you up while you're working on SQL Server Integration Services packages in Business Intelligence Development Studio (BIDS). Thanks to my buddy Jason Howell, who's an SSIS whiz in Microsoft Support, for sending us this list...
-
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...
-
If you've had a seemingly obscure problem with Integration Services, you may not be alone! Microsoft Support may already have explored it and documented it in a Knowledge Base article. Here's a list of the published KB articles for SSIS, both 2008 and 2005. A big thanks to my buddy in Support...
-
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...