March 2009 - Posts

Import from a macro-enabled Excel 2007 workbook (*.xlsm) (CORRECTED)

Published 31 March 9 12:35 PM | dougbert

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...

Filed under: Excel

Get looped, with your own custom Foreach Enumerator for SSIS

Published 27 March 9 1:35 PM | dougbert

The lack of control flow structures such as looping was one of the main shortcomings of Data Transformation Services (DTS). If you're nostalgic, just look at the scripting hoops that you had to jump through to loop, by disabling and re-enabling steps...

Filed under: programming, custom components

Find the top Knowledge Base articles for DTS

Published 17 March 9 3:26 PM | dougbert

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...

Filed under: DTS, known issues

Find the top Knowledge Base articles for SSIS

Published 17 March 9 9:45 AM | dougbert

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...

Filed under: known issues

Solve some common pain points in BIDS

Published 16 March 9 3:46 PM | dougbert

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...

Filed under: known issues, BIDS

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

Published 16 March 9 12:28 PM | dougbert

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...

Filed under: 64-bit, BIDS