Dougbert on SSIS

Speed up your ETL with 4 new SSIS performance videos from Microsoft

dougbert — Thu, 30 Apr 2009 22:38:00 GMT

SSIS: Designing and Tuning for Performance SQL Server Video Series Learn the details of SQL Server Integration Services performance tuning from the people who know it best! Today (4/30/09) Microsoft published 4 new videos on SSIS performance, recorded...(read more)

HTML Table Destination: An (incomplete) SSIS custom data flow component

dougbert — Tue, 28 Apr 2009 22:33:00 GMT

I had fun recently creating a custom data flow destination for Integration Services - an HTML Table Destination that writes out the data from the data flow to an HTML file as an HTML table. No applause, please - I copied SSIS developer Matt Masson's...(read more)

Off topic? Pretty charts, and SSIS in Siberia

dougbert — Mon, 27 Apr 2009 21:11:00 GMT

I was crushed by the news that Microsoft AdCenter Analytics was being discontinued. As a beta user, I'd enjoyed the pretty charts about visits to my blog. Where was I going to get pretty charts now (without implementing BI of my own, at least)? So...(read more)

Logging custom events for Integration Services tasks

dougbert — Mon, 13 Apr 2009 22:57:00 GMT

All Integration Services tasks and containers support a default set of events for logging. These events typically represent different stages in the "lifetime" of the object at run time, such as "OnPreExecute", "OnPostExecute"...(read more)

No need to call Support for these common challenges in SSIS

dougbert — Sun, 12 Apr 2009 23:16:00 GMT

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...(read more)

SSIS and clustering: What you should do instead

dougbert — Thu, 09 Apr 2009 23:25:00 GMT

Lots of customers ask about configuring SQL Server Integration Services in a failover cluster. We recommend that you DON'T configure SSIS as a cluster resource. There are almost no benefits to doing so, and you can gain many of the benefits that you...(read more)

Understand how SSIS package configurations are applied

dougbert — Tue, 07 Apr 2009 21:06:00 GMT

This week I'm cleaning up our BOL documentation about how SSIS package configurations are applied, and how the behavior has changed between SQL Server 2005 and SQL Server 2008 Integration Services. These changes affect what you can and can't do...(read more)

Setting the DataType of IDTSParameterBinding objects (Execute SQL Task)

dougbert — Tue, 07 Apr 2009 18:18:00 GMT

If you're writing Integration Services code that uses the Execute SQL task, you also have to create parameters programmatically. The ParameterBindings property of the ExecuteSQLTask returns an IDTSParameterBindings collection of IDTSParameterBinding...(read more)

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

dougbert — Tue, 31 Mar 2009 19:35:00 GMT

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...(read more)

Get looped, with your own custom Foreach Enumerator for SSIS

dougbert — Fri, 27 Mar 2009 20:35:00 GMT

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...(read more)

Find the top Knowledge Base articles for DTS

dougbert — Tue, 17 Mar 2009 22:26:00 GMT

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...(read more)

Find the top Knowledge Base articles for SSIS

dougbert — Tue, 17 Mar 2009 16:45:00 GMT

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...(read more)

Solve some common pain points in BIDS

dougbert — Mon, 16 Mar 2009 22:46:00 GMT

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...(read more)

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

dougbert — Mon, 16 Mar 2009 19:28:00 GMT

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...(read more)

Import EBCDIC in SSIS packages with updated Lysine 1.1

dougbert — Fri, 20 Feb 2009 14:40:00 GMT

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...(read more)