Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Katmai   (RSS)

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
Posted by mmasson | 2 Comments
Filed under:

SQL Server 2008 RTM is Live

The RTM version of SQL Server 2008 is now available for MSDN and Technet subscribers. Hurray!
Posted by mmasson | 2 Comments
Filed under:

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
Posted by mmasson | 1 Comments

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
Posted by mmasson | 1 Comments
Filed under: ,

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,
Posted by mmasson | 0 Comments
Filed under: ,

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
Posted by mmasson | 1 Comments
Filed under:

SQL Server 2008 RC0 is now available

Incase you missed it through the other channels, RC0 is now available for download . Also see: Books Online Readme Release Notes Feature Pack
Posted by mmasson | 0 Comments
Filed under:

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.
Posted by mmasson | 0 Comments
Filed under: ,

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.
Posted by mmasson | 3 Comments
Filed under: , ,

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
Posted by mmasson | 0 Comments
Filed under:

Package Upgrade Wizard

SSIS packages created in 2005 have to go through an upgrade process to run in 2008. 2008 packages created prior to the February CTP also have to be upgraded. The upgrade kicks in automatically once the package is loaded by the runtime - whether in the
Posted by mmasson | 2 Comments
Filed under:

Upgrading scripts from early 2008 CTPs

The February CTP has been out almost a month now, but just incase you hadn't checked it out yet, I thought I'd post a heads up. The February CTP introduced Visual Studio 2008 (Orcas), replacing Visual Studio 2005 as our Business Intelligence Designer
Posted by mmasson | 1 Comments
Filed under: ,

Some notes about SQL Native Client in 2008

The SQL Native Client (SNAC) provider was renamed from SQLNCLI to SQLNCLI10 in 2008. The means that connection strings that used the Yukon provider (SNAC9) won't work if you only have the Katmai provider (SNAC10) installed. This will affect most SSIS
Posted by mmasson | 2 Comments
Filed under: ,

Data profiling task improvements

There's been some great feedback coming in about the new data profiling task. Jamie Thompson has a set of blog posts that cover all of the different profile options, and yesterday I read an interesting post from John Welch which describes a clever way
Posted by mmasson | 2 Comments
Filed under: ,

Custom Extensions in SQL Server 2008

The introduction of new SSIS features in the SQL Server 2008 release and beyond made it necessary for the SSIS team to introduce some breaking changes that affect SSIS custom extensions built for SQL Server 2005. This post is intended to clarify what
Posted by mmasson | 2 Comments
Filed under:
More Posts Next page »
 
Page view tracker