Blog - Title

  • SSIS Team Blog

    Creating a custom task with a default UI

    • 7 Comments
    The Developing a User Interface for a Custom Task entry in Books Online describes how to build your UI from scratch, but there is an easier way to create a UI that has the same look and feel as the stock tasks that ship with SSIS. The Microsoft.DataTransformationServices...
  • SSIS Team Blog

    Fuzzy Lookup similarity scores

    • 1 Comments
    I recently received this question about Fuzzy Lookup behavior (paraphrased): We are seeing something very strange within the Fuzzy Lookup component. When you have different ref tables, both containing the same value, but one having a lot more data, you...
  • SSIS Team Blog

    Reporting on execution logs using Reporting Services

    • 1 Comments
    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...
  • SSIS Team Blog

    MDDE - MetaData Driven ETL

    • 4 Comments
    If you haven't read about MDDE yet, be sure to read the blurb on the MDDE Codeplex homepage . There's currently not much documentation about it, but I plan on sharing things about it as I start to learn how to use it myself.  The MDDE process: Create...
  • SSIS Team Blog

    Use 32bit runtime option for SQL Agent

    • 1 Comments
    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...
  • SSIS Team Blog

    SQL Server 2008 RC0 is now available

    • 0 Comments
    Incase you missed it through the other channels, RC0 is now available for download . Also see: Books Online Readme Release Notes Feature Pack
  • SSIS Team Blog

    New SSIS Blog

    • 0 Comments
    Douglas Laudenschlager, one of our excellent documentation writers, has started a blog on his site, Dougbert.com . He has a number of great posts so far , and he's only been at it for a month. Frankly, the quality of his blog is making me feel bad about...
  • SSIS Team Blog

    Matthew Roche on RunAs Radio

    • 0 Comments
    Matthew recently did an interview for RunAs radio where he gives a really good overview of SSIS, DTS, and ETL in general. It's great if you're just getting started with SSIS, or need to sell someone else on the idea of using it!
  • SSIS Team Blog

    Improved error messages about missing OLEDB providers

    • 3 Comments
    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...
  • SSIS Team Blog

    Package upgrade - connection strings

    • 3 Comments
    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...
  • SSIS Team Blog

    Integration Services Samples for SQL Server 2008

    • 0 Comments
    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...
  • SSIS Team Blog

    Samples for MDDE

    • 1 Comments
    They've updated the MDDE project on codeplex with new code, screen shots, and some samples. Check it out here .
  • SSIS Team Blog

    Vulcan

    • 1 Comments
    What a week! Hot on the heels of MDDE appearing on Codeplex, another internal MS solution for generating SSIS packages dynamically appears . I saw a Vulcan demo a couple of months ago, and was really impressed. It generates SSIS packages from XML definition...
  • SSIS Team Blog

    Package Submission Program

    • 1 Comments
    Anjan Das (SSIS Program Manager) has posted about the SSIS Package Submission Program in the forums. The goal of the program is to further test out our 2005 to 2008 upgrade process, and identify any issues prior to RTM. Here are all the details: THE MICROSOFT...
  • SSIS Team Blog

    Setting package upgrade options in the designer

    • 2 Comments
    You can set a couple of package upgrade options in the designer through the SSIS options page (Tools -> Options...) These defaults will be used anytime you upgrade a 2005 package through the designer. See my post about the Upgrade Wizard for more details...
  • SSIS Team Blog

    MDDE appears on Codeplex

    • 4 Comments
    The SQL Server Metadata-Driven ETL Studio (MDDE) was an internal MSIT project first shown at the MS BI Conference last year. The initial release is now up on Codeplex . There isn't much information up about it yet, but I'm told that docs and examples...
  • SSIS Team Blog

    Flurry of blogging activity

    • 1 Comments
    Incase you're wondering about the increased blog activity - I'm currently working out of the new MS development office in Shanghai, China. I figured the 16 hours I spent traveling yesterday was a good time to catch up on some blogging. I'll be here for...
  • SSIS Team Blog

    Package Upgrade Wizard

    • 2 Comments
    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...
  • SSIS Team Blog

    Upgrading scripts from early 2008 CTPs

    • 1 Comments
    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...
  • SSIS Team Blog

    Some notes about SQL Native Client in 2008

    • 2 Comments
    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...
  • SSIS Team Blog

    Accessing a data profile programmatically

    • 14 Comments
    The new Data Profiling Task in 2008 generates an XML output file. The output is easy to read, and could be used to make decisions within a control flow. For example, you could check whether or not to process your most recent data set based on criteria...
  • SSIS Team Blog

    Data profiling task improvements

    • 2 Comments
    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...
  • SSIS Team Blog

    New connectivity options in 2008

    • 14 Comments
    Update: 2008-08-13 - The connector pack will be available two to three months from the GA of SQL 2008 Update: 2008-10-02 - The Oracle and Teradata connectors are now available Update : 2008-11-26 - The SAP BI connections are available Darvey...
  • SSIS Team Blog

    Connecting to MySQL from SSIS

    • 19 Comments
    Update: See this follow-up post on writing data to MySQL . I've recently seen a bunch of questions about connecting to MySQL from SSIS, so I thought I'd give it a try. My overall findings was that while there were quirks, both the ODBC and ADO.Net...
  • SSIS Team Blog

    Lookups with Visual FoxPro

    • 1 Comments
    Here's a quick tip from a couple other members of the SSIS team, Da Lin and David Noor. If you have a lookup component using partial cache mode using a Visual FoxPro oledb provider to connect to your reference table, be sure to change the OLE DB Services...
Page 8 of 10 (239 items) «678910