April 2009 - Posts

Speed up your ETL with 4 new SSIS performance videos from Microsoft
Published 30 April 9 3:38 PM | dougbert
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...
Filed under: ,
HTML Table Destination: An (incomplete) SSIS custom data flow component
Published 28 April 9 3:33 PM | dougbert
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...
Filed under: ,
Off topic? Pretty charts, and SSIS in Siberia
Published 27 April 9 2:11 PM | dougbert
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...
Filed under:
Logging custom events for Integration Services tasks
Published 13 April 9 3:57 PM | dougbert
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"...
Filed under:
No need to call Support for these common challenges in SSIS
Published 12 April 9 4:16 PM | dougbert
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...
Filed under:
SSIS and clustering: What you should do instead
Published 9 April 9 4:25 PM | dougbert
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...
Filed under: ,
Understand how SSIS package configurations are applied
Published 7 April 9 2:6 PM | dougbert
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...
Filed under: ,
Setting the DataType of IDTSParameterBinding objects (Execute SQL Task)
Published 7 April 9 11:18 AM | dougbert
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...
Filed under: ,