Mar
17
2009

Find the top Knowledge Base articles for SSIS

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 hits a higher number means it got fewer  0 (zero) means it didn't get any. I have sorted the list on the Total column from most viewed to least viewed. This list does not distinguish between SQ... [More]
Mar
16
2009

Solve some common pain points in BIDS

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 recently. 1. Make that "Visual Studio is busy" message go away! Validation happens often in BIDS and can be slow, especially if you're connecting to slow or unavailable data sources. Possi... [More]
Mar
16
2009

Debug your packages in 32-bit or 64-bit mode

At run time, you decide the "bitness" of Integration Services package execution on a 64-bit computer by running the 32-bit or the 64-bit version of the dtexec.exe command prompt utility. At design time in Business Intelligence Development Studio, you can also specify the "bitness" for running the package from within BIDS. The default setting is 64-bit execution. (This setting is ignored on a 32-bit computer, or if you've only installed 32-bit SQL Server on a 64-bit computer.) But on a 64-bit computer, ... [More]
Feb
20
2009

Import EBCDIC in SSIS packages with updated Lysine 1.1

You can now import EBCDIC data more reliably in SQL Server Integration Services packages with version 1.1 of "Lysine", just announced by Patrick & Ben at Amino Software. If you work with EBCDIC dta, what's in it for you? "The major benefits of Lysine are two-fold: It saves you from having to write a pre-processor to unpack and convert the binary data. It prevents you from having to pre-process the data saving an extra, and many times costly, trip through the data." Here's the features list from t... [More]
Feb
13
2009

Exporting data from SSIS to Excel 2007: Gotchas

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 that are supported in Excel. Our SQL Server Books Online topic, How to: Connect to an Excel Workbook, contains incomplete and potentially misleading information when it tells you to set Extended Properties ... [More]
Feb
11
2009

Not happy with a Books Online topic? Rewrite it yourself!

OK, you can't do this directly. But you can do the next best thing! Use the Community Content feature in the MSDN Library to add more information, examples, clarifications, or corrections for all to see. Let's take a look at this Integration Services page in SQL Server 2008 Books Online as an example (link opens in a new window): Configuring the Integration Services Service. To read community content: 1. At the top of the article, observe the Community Content box at the upper right. For this BOL topic, you... [More]
Feb
10
2009

Add helpful package design tools to BIDS: A Codeplex project focus

Among the gems on found on Codeplex, "Microsoft's open source project hosting web site", BIDS Helper stands tall. BIDS Helper is "a Visual Studio.Net add-in with features that extend and enhance the functionality of Business Intelligence Development Studio (BIDS)." It supports SQL Server 2005 and 2008. It includes helpful tools for Analysis Services (22), Integration Services (14), and Reporting Services (2). It won the "SQL Heroes 2008" contest award as announced at t... [More]
Feb
9
2009

Just Published: The Data Loading Performance Guide

Read the new white paper on optimizing bulk inserts from the SQLCAT team: The Data Loading Performance Guide Be prepared for technical depth, including hardware and networking optimizations!    
Jan
26
2009

View Help for the SAP BI Connector for SSIS on the Web

Today the Help file for the Microsoft Connector 1.0 for SAP BI was published to the MSDN Library at this address: http://msdn.microsoft.com/en-us/library/dd326764.aspx. Previously, customers who were interested in the Connector had to download the components and install them to get access to the Help documentation. This Help content (which does not contain screen shots) complements the valuable how-to article (which DOES contain screen shots) by Chunhui Zhu, Using SQL Server 2008 Integration Services with ... [More]
Jan
20
2009

Learn more about Data Profiling in SQL 2008: A compilation

Microsoft Research contributed the Data Profiling Task and Data Profile Viewer to Integration Services in SQL Server 2008. Best of all, this feature is available in all editions of SQL Server that include SSIS, and not just in Enterprise. Learn more about this new task from the following resources. By their nature, SSIS package developers see the XML output from the Data Profiling task, and immediately want to process it in an SSIS package! I've marked the 3 relevant resources below with an asterisk (*... [More]