Blog - Title

July, 2011

  • SSIS Team Blog

    Parameterized Connection Managers

    • 4 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

    SSIS - What’s New in SQL Server Denali

    • 17 Comments
    What’s new in SSIS? In a word: Lots . It’s been a lot of fun showing off the new SSIS features and functionality – the hardest part has been fitting it all into a 60 minute timeslot. This CTP is close to feature complete – the...
  • SSIS Team Blog

    Overview of the DQS Cleansing Transform

    • 12 Comments
    Data Quality Services is a new SQL Server product in Denali which provides data cleansing capabilities. This post describes how to make use of the DQS Cleansing Transformation which is part of the default set of SSIS data flow components. The DQS Cleansing...
  • SSIS Team Blog

    Configuring Projects and Packages Using Parameters

    • 2 Comments
    Today’s post is from Rakesh Parida, an SDET on the SQL Server Integration Services team. ------------------------------------------------ With SQL Server ‘Denali’, we introduce the new paradigm of parameters. Parameters are objects within the SSIS packages...
  • 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

    A Glimpse of the SSIS Catalog Managed Object Model

    • 10 Comments
    Today’s post is from Ke Yang – a developer on the SSIS Team based in Shanghai. It provides a quick overview of the new Managed Object Model (MOM) for the SSIS Catalog. --------------------------------------- The namespace Microsoft.SqlServer.Management...
  • SSIS Team Blog

    Using DTEXEC with Packages on the IS Server

    • 1 Comments
    Today’s post is by Terri Chen – a developer on the SQL Server Integration Services team. -------------- In Denali, the project is a unit of packages that are deployed to the server. DTExec has been enhanced to support executing packages stored in the...
  • SSIS Team Blog

    Changes to the Execute Package Task

    • 3 Comments
    Todays post is from Terri Chen, a developer on the SQL Server Integration Services team. -------------------------- SSIS has introduced new concepts in SQL Server “Denali”, such as the project deployment mode, projects and parameters . We have extended...
  • SSIS Team Blog

    Offline Connection Managers

    • 1 Comments
    Today’s post is from Carla Sabotta, lead writer for the SQL Server Integration Services team. ------------------------------------------------------------------- The SSIS Designer in BIDS tries to connect to each data source that is used by your package...
  • SSIS Team Blog

    Deploying to the SSIS Catalog

    • 6 Comments
    Today’s post is from Ranjeeta Nanda. Ranjeeta is an SDET (Software Development Engineer in Test) on SQL Server Integration Services team. She has been with the team since May 2004. Before joining Microsoft, she worked at Merkle Direct Marketing, Maryland...
  • 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

    Flat File Source Changes in Denali

    • 8 Comments
    Nearly everyone uses the flat file source adapter, and nearly everyone that uses it runs into a common set of challenges. In Denali, we’ve made a couple of key enhancements to the Flat File Source to support the most commonly asked-for options: Delimited...
  • SSIS Team Blog

    All About Server Environments

    • 0 Comments
    Today’s post is from Renhe Li – a developer on the SSIS team based in Shanghai. ----------------- Server Environments are a new concept introduced in SQL Server Denali for the Integration Services Catalog. It is a container for “server variables”. Each...
  • 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

    Jumping-start SSIS Catalog procedures from SSMS Dialogs

    • 0 Comments
    Today’s post is from Ke Yang – a developer on the SSIS team based in Shanghai. ----------------------------------- At times, we need T-SQL scripts to do batch jobs or to communicate with others. Since IS Catalog provides rich functionalities with over...
  • SSIS Team Blog

    30 Days of SSIS

    • 0 Comments
    To celebrate the release of the new SQL Server Denali CTP , the SSIS team will be doing a series of Denali focused blog posts. Over the next 30 days, the SSIS team will be posting one (or more) blog entries each day which cover some of the new SSIS features...
  • SSIS Team Blog

    SSIS Training in the UK – SQLBits 9

    • 0 Comments
    I’m really excited to be presenting at SQLBits 9 in September! The conference will be full of great SSIS content, and I wanted to call out the training opportunity available at the pre conference (on September 29th). There will be two full day training...
Page 1 of 1 (18 items)