Blog - Title

  • SSIS Team Blog

    Project Connection Managers

    • 5 Comments
    Today’s post is by Sergio Clemente Filho – a developer on the SQL Server Integration Services team. --------------------------------------   Simple Project Connection example in BIDS One of the first new things you will notice in the solution explorer...
  • SSIS Team Blog

    API Sample – Data Conversion

    • 5 Comments
    This sample creates a data flow package with an OLEDB Source and a Data Convert transform. The transform converts the CustomerKey column (int) to a WSTR(50), and stores the result in the CustomerKeyAsString column. static void Main( string [] args) ...
  • SSIS Team Blog

    No new features in for Integration Services in SQL Server 2008 R2

    • 5 Comments
    Update 2009-11-12 : One minor feature change announced . Have you been holding your breath waiting for Microsoft to announce the new SSIS features for SQL Server 2008 R2 ? The answer is pretty simple – nothing new is being added for SSIS in R2....
  • SSIS Team Blog

    Regular Expression Flat File Source

    • 5 Comments
    The RegEx flat file source is one of the new community samples for SQL Server 2008 we’ve published to Codeplex. It uses regular expressions to extract values from a text file. It works similar to the flat file source, except that it’s not limited to CSV...
  • 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

    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

    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

    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

    Handling Slowly Changing Dimensions in SSIS

    • 4 Comments
    I had a great time at PASS last week, and had a chance to talk to a lot of different SSIS users. One of the big topics seemed to be Slowly Changing Dimensions – I had a number of people ask for various improvements to the current Slowly Changing...
  • SSIS Team Blog

    Avoiding Common Pitfalls in SSIS

    • 4 Comments
    I’ve uploaded the slides for the Chalk Talk I gave at TechEd last week. I always appreciate feedback (good or bad), and I’ve gotten some great comments so far. If you attended the session (or just like the slides), feel free to comment below.
  • SSIS Team Blog

    Lookup Pattern: Key Generation

    • 4 Comments
    This pattern is used when you have transformation logic which relies on a key which might not already exist. If the lookup fails to find the key, a new key is generated with a script task so it can be used later on downstream. Optionally, the key could...
  • SSIS Team Blog

    Lookup Pattern: Upsert

    • 4 Comments
    This is a pretty basic pattern where we use a lookup to determine whether we need to update and existing row, or insert a new one. The lookup checks if a key or set of values exists. If the key isn't found, the row is sent to an OLEDB Destination for...
  • SSIS Team Blog

    Managing SSIS Projects through SSMS

    • 4 Comments
    Before you can deploy your Projects to the SSIS Server , you’ll need to create a new SSIS Catalog through SSMS. Connect to your SQL Server instance (local or remote), right click on the Integration Services node, and select Create Catalog. This will launch...
  • SSIS Team Blog

    SQL 2012 Connectors for Oracle & Teradata Coming Soon

    • 4 Comments
    An updated version of the Attunity Connectors for Oracle & Teradata are not yet available on the Microsoft.com download center, but will be up there soon. The plan is to have these connectors available in Q1 of this year. The basic functionality will...
  • SSIS Team Blog

    The Balanced Data Distributor

    • 4 Comments
    Today’s post isn’t specifically about SQL Server Denali, but still a worthy addition to the 30 Days of SSIS series. The Balanced Data Distributor is a new data flow component created by the SQLCAT team , and available for download from Microsoft.com ...
  • SSIS Team Blog

    Parameterized Connection Managers

    • 3 Comments
    Today’s post is from Bob Bojanic – a developer on the SSIS Team. --------------------------- There is often a need to update connection manager properties for subsequent package runs. Whether you need to point to a different server or change credentials...
  • SSIS Team Blog

    Troubleshooting SSIS Package Performance Issues

    • 3 Comments
    Today’s post is from Wee Hyong Tok, a Program Manager with the SSIS team based in Shanghai. It provides some tips on using T-SQL to analyze performance issues for packages running on the new SSIS Catalog. For more information about the new logging functionality...
  • SSIS Team Blog

    Making your Existing Custom SSIS Extensions and Applications Work in Denali

    • 3 Comments
    Today’s post is from Rujin Cao – a developer on the SSIS team based in Shanghai. This article talks about the .NET assembly binding we include in our .exes by default, which makes migrating custom SSIS code to Denali a lot easier. Note that while this...
  • SSIS Team Blog

    Changing Variable Scope and other Enhancements

    • 3 Comments
    In SQL Server 2012, SSIS includes some very useful enhancements to package variables. You can now change the scope of an existing package variable. Just select the variable in the Variables window and click the new Move Variable icon. Then, in...
  • SSIS Team Blog

    SSIS Catalog - Backup and Restore

    • 3 Comments
    Integration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data. So backup and restore of SSIS catalog across machines need some extra steps in addition to the usual backup and restore steps. This...
  • SSIS Team Blog

    EzAPI Updated for SQL Server 2012

    • 3 Comments
    The EzAPI project has been updated for the SQL Server 2012 release. You can find the updated source code here . Changes Task and Component IDs updated for SQL 2012 For 2005/2008 support, please use a previous version of the code Project upgraded to .NET...
  • SSIS Team Blog

    Migrating Your Projects to Denali

    • 3 Comments
    Today’s post is from Carla Sabotta, lead writer for the SQL Server Integration Services team. It covers the new Integration Services Migration Wizard, which has been renamed to the “Project Conversion Wizard” in recent builds. Enjoy...
  • SSIS Team Blog

    The Right Tool for the Job

    • 3 Comments
    Most of this content comes from my Performance Design Patterns series. If you’re interested in learning more about SSIS Design Patterns, I’ll be doing full day pre-conference training sessions at the PASS Summit and SQLBits . ---------- Whenever I’m presenting...
  • SSIS Team Blog

    What’s New in “Denali” for SSIS – TechEd 2011

    • 3 Comments
    I presented a “What’s New in Microsoft SQL Server Code-Named Denali for SQL Server Integration Services” talk at TechEd last week, which is now available online . It will show you a sneak peak of what we’ll be delivering in the next CTP of Denali . The...
  • SSIS Team Blog

    Deploy SSIS 2012 projects using catalog.deploy_project Stored Procedure

    • 3 Comments
    In SQL Server 2012, you can use the catalog.deploy_project stored procedure to deploy an SSIS project to the SSIS server. You need to provide the binary contents of the project deployment file (.ispac extension), for the @project_stream parameter, along...
Page 3 of 10 (239 items) 12345»