Competitive Comparison of SQL Server 2008 Integration Services

Did you know about this white paper comparing SSIS to IBM Information Server (DataStage), Informatica PowerCenter, Oracle Warehouse Builder, and Oracle Data Integrator? I had heard rumors of its existence, but I hadn’t actually seen the links for it until now. I saw a lot of good points in there, but looking at the chart…


SSWUG Business Intelligence Virtual Conference

I’ve been invited to speak at the SSWUG BI Virtual Conference in September. Like John Welch mentioned in his blog, the current speaker lineup is very impressive. I’m honored (and a little intimidated) to be on the presenters list! I’ll be flying out to Tucson in early September to record three SSIS related sessions: What’s…


First two community samples for 2008 now on Codeplex

The Integration Services Community Samples project is now active on Codeplex. These samples are being created by the SSIS product team to supplement the content in books online, and the Product Samples for 2008. They will (hopefully) provide useful functionality that you can then take an customize for your ETL solutions. The first two samples…


Reporting on execution logs using Reporting Services

Microsoft published a set of canned reports for RS a while back. The pack includes some reports for Integration Services that give you execution results and statistics for your packages (if they are using SQL Server logging). The reports are very handy, and provide a good starting point if you want to create your own…


Use 32bit runtime option for SQL Agent

To add to Doug’s recent post about 64bit platform considerations, here’s a screen shot (fresh from RC0) of the new "Use 32bit runtime" option on the SQL Agent job configuration screen. You’ll find it on the "Execution options" tab.


Improved error messages about missing OLEDB providers

We’ve modified the OLEDB_NOPROVIDER error to return the name of the provider we failed to find. This will appear in the RC0 release of SQL 2008. SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider SQLNCLI.1 is not registered. Error code: 0x0000000 This should help in debugging issues related to connection string upgrades.


Package upgrade – connection strings

We tried to make our package upgrade as seamless as possible, but one problem we’ve seen people running into is with their connection strings. As I’ve previously noted, the provider name for SQL Native Client was changed in 2008 from SQLNCLI to SQLNCLI10. This will could cause your connection managers to fail at runtime, as…


Integration Services Samples for SQL Server 2008

Now that things are winding down for SQL Server 2008, we’ve had some time to focus on samples. I’m especially interested in publishing sample extensions (tasks, data flow components, etc) out on codeplex, but we’re also working on SSIS package samples that make use of some new functionality in 2008. Here are some of the…