Blog - Title

  • SSIS Team Blog

    SSIS sets an ETL world record

    • 3 Comments
    They mentioned the TPC benchmark results at the SQL Server 2008 launch today. The final paragraph mentions a world record for ETL load performance. The fine folks who maintain the SQLPerf blog have posted details about the result , explaining how they...
  • SSIS Team Blog

    MVP Summit

    • 2 Comments
    The 2008 MVP Summit is coming up soon - April 14th to 17th. Last year was my first year with SSIS, and I really enjoyed meeting some of our MVPs. The summit is a great chance for us to talk to professionals out in the field, and get a deeper insight into...
  • SSIS Team Blog

    Custom Extensions in SQL Server 2008

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

    Memory Dump - Sample

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

    What's new in SQL Server 2008 for SSIS - Part two

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

    What content do you want to see here?

    • 8 Comments
    There are a lot of SSIS blogs out there, and I don't like being redundant. I'm hoping to find more time to blog, which got me thinking about what I should be writing about. What type of information would you most like to see posted here? Details about...
  • SSIS Team Blog

    What's new in SQL Server 2008 for SSIS - Part one

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

    No more implicit lookup cache sharing in Katmai

    • 4 Comments
    The November CTP for SQL Server 2008 introduced our new Lookup Transform. 2005 packages with lookup components will upgrade automatically when opened/run in 2008, and should function the same as they did in 2005 with one minor caveat. In certain scenarios...
  • SSIS Team Blog

    XML Source - Making things easier with XSLT

    • 12 Comments
    As I wrote in my previous post , complex XML documents will produce multiple outputs when you're using the XML Source adapter. Most of the time it will be easier to pre-process your source file with XSLT to de-normalize it a bit. Reducing the number of...
  • SSIS Team Blog

    Using XML Source

    • 22 Comments
    Providing a generic way to extract data from XML documents of any format is pretty complicated. The SSIS XML Source Adapter tries to do just that, to various degrees of success. XML Source is easiest to use when your input has a simple element/sub-element...
  • SSIS Team Blog

    SSIS Survey

    • 0 Comments
    The SQL User Experience (SQLUX) and Integration Services team are currently conducting a survey on ETL practices. We hope to use this feedback in our planning for the Katmai end game, and follow up releases. If you fill out the survey before December...
  • SSIS Team Blog

    Transfering a couple of tables at a time

    • 2 Comments
    I missed some of the comments to my post about creating your own Transfer SQL Objects Task with a script task , so I thought I'd post the answer here incase people miss my answer. You can use the ObjectList property of the Transfer object to specify which...
  • SSIS Team Blog

    Running packages from custom applications

    • 2 Comments
    There are a lot of different ways to run SSIS packages , and many situations call for a custom package launcher application. If you're coding your own launcher, one thing to keep in mind is that certain SSIS functionality (such as the Script task / component...
  • SSIS Team Blog

    Capture PRINT messages from a stored procedure

    • 7 Comments
    I recently helped with a customer issue where they had a long running stored procedure which output status messages periodically using PRINT statements. They wanted to capture these statements and output them into the SSIS log. Unfortunately, the Execute...
  • SSIS Team Blog

    Optional date parameter

    • 4 Comments
    This was part of the solution to the project my team was working on (that I'm still in the process of writing up), but I thought I'd post it separately because it has various uses. The Problem We have a package which does some aggregations based on a...
  • SSIS Team Blog

    Data flow improvements in Katmai

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

    SQL Native Client 10 - provider name change

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

    Select variables dialog

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

    Katmai - Script tasks which use the SSIS object model

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

    Katmai - Custom components and upgrade

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

    First public Katmai CTP

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

    Real world scenarios

    • 2 Comments
    May has been a busy month! The first Microsoft Business Intelligence conference was earlier in the month, and it seemed to be a big success. I was amazed at how many people were there, and I met a lot of interesting people when I was manning the demo...
  • SSIS Team Blog

    Getting optimal lookup performance

    • 0 Comments
    Just a quick post to link to an SSIS article posted on the sqlperf blog - Getting Optimal Performance with Integration Services Lookups
  • SSIS Team Blog

    Why can’t I store my BIGINT result in an Int64 variable?

    • 13 Comments
    The native providers (OLEDB, ODBC, ADO – ADO.NET doesn't have this problem) in the Execute SQL Task return the BIGINT type as a String, and not an Int64 as you'd expect. Attempting to store the result in an Int64 variable gives you an error along the...
  • SSIS Team Blog

    Roll your own Transfer SQL Server Objects task

    • 28 Comments
    Awhile back we went through a lot of customer feedback logged through the Connect site concerning the Transfer SQL Server Objects task. Some of these turned out to be bugs, but a lot of the reported issues stemmed from usability problems with the task...
Page 9 of 10 (239 items) «678910