Browse by Tags

Tagged Content List
  • Blog Post: 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,...
  • Blog Post: SQL Server 2008 RTM is Live

    The RTM version of SQL Server 2008 is now available for MSDN and Technet subscribers. Hurray!
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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.
  • Blog Post: 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
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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....
  • Blog Post: 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 designer, dtexec, or through the API. To make the...
  • Blog Post: 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 Studio (BIDS).[ side note - why is it I always misspell...
  • Blog Post: 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 users, as we use SNAC as the default connection manager...
  • Blog Post: 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 to profile an entire database . I wanted to mention...
  • Blog Post: 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 those breaking changes are and how to migrate your...
  • Blog Post: Memory Dump - Sample

    In my last post I mentioned the enhanced memory dumping we've added to SQL Server 2008. Along with the dump file, we create a text file that has additional information that will help in debugging the issue. I thought I'd include a sample of it, here. System Info # SSIS Textual Dump taken at 8/29/2007...
  • Blog Post: What's new in SQL Server 2008 for SSIS - Part two

    Change Data Capture (CDC) While not a direct SSIS feature, the new Change Data Capture functionality in 2008 can be taken advantage of in SSIS to do incremental loads. CDC captures changes to SQL Server tables (inserts, updates, deletes), and makes them available in an "easily-consumed, relational...
  • Blog Post: What's new in SQL Server 2008 for SSIS - Part one

    Improved Scripting SQL Server 2008 (Katmai) introduces VSTA as our new scripting engine, which replaces the old VSA engine used in SQL Server 2005 (Yukon). There are a number of advantages to the new engine, but I think the feature users are most excited about is that it allows you to use C# as a scripting...
  • Blog Post: Data flow improvements in Katmai

    As I previously mentioned , the current Katmai CTP contains a pretty major reworking of how data flow tasks get executed. Michael Entin has written up an overview of the changes that should be of interest to any long time SSIS users.
  • Blog Post: SQL Native Client 10 - provider name change

    The provider name for SQL Native Client (SNAC) connections has changed in Katmai. Since this is the default provider for OLEDB connections, you'll probably be affected by this change if you're running SQL Server 2005 packages in Katmai. Version Provider name SQL Server 2005 (Yukon) SQLNCLI.1 SQL Server...
  • Blog Post: Select variables dialog

    A nice convenience feature in the new VSTA based script task is that we now provide a variable selection dialog for the ReadOnlyVariables and ReadWriteVariables properties. Ok, so there's not much content in this post. I admit it - this was just a reason for me to play around with some of the plug-ins...
  • Blog Post: Katmai - Script tasks which use the SSIS object model

    [ Edit: Note, this has been resolve in current Katmai CTPs ] You may run into issues in the current Katmai CTP if your script task uses objects contained within the ManagedDTS assembly. If you're interested in the details, keep reading - otherwise you can skip to the bottom for a possible work around...
  • Blog Post: Katmai - Custom components and upgrade

    (Note, when I use the word "components" in this post, I'm referring to all extensible items, including tasks, pipeline components, foreach enumerators, loggers and connections) The first major change I worked on as part of the SSIS team was re-versioning our components for Katmai. This included: ...
  • Blog Post: First public Katmai CTP

    The first public community technology preview for SQL Server 2008 (code named Katmai) was announced at TechEd yesterday, and is now available for download. You can register here to download the developer editions, and post questions / comments / concerns in the special Katmai MSDN forums they have setup...
Page 1 of 1 (24 items)