SSIS Team Blog

Helpful information and examples on how to use SQL Server Integration Services.

Blog - About

About this blog

A blog about SQL Server Integration Services (SSIS) from a developer on the team.

  • SSIS Team Blog

    Changing the Data Viewer font size

    • 0 Comments
    Did you know you could change the font size in a data viewer grid? If you’re like me and frequently demo SSIS on a big screen (or if you’re just tired of a 8 point font size), this is extremely handy. You can find the setting as a Visual Studio option...
  • SSIS Team Blog

    Presenting at the Ottawa Code Camp – April 16th

    • 0 Comments
    I’ve been invited to present about SSIS at the Ottawa IT Camp on April 16th, 2011. I’ll be presenting a 250 level version of my SSIS Design Patterns talk. I’m also looking forward to meeting Christian Cote and Jean-Rene Roy, who will also be presenting...
  • SSIS Team Blog

    Pattern: Replacing NULL values with a Derived Column

    • 2 Comments
    This pattern has been out there for so long I had contemplated taking it out of my Performance Design Patterns talk, but it looks like it still managed to help some people at SQL Saturday #71 last weekend. This pattern is straight forward, and especially...
  • SSIS Team Blog

    Presenting at Microsoft Tech Ed

    • 0 Comments
    I’m happy to once again have the chance to talk about SSIS at Tech Ed North America. I’ll be presenting two sessions this time around – a Denali focused break-out session, and an interactive session about how to scale out SSIS, which...
  • SSIS Team Blog

    Speaking at SQL Saturday #71 - Boston

    • 2 Comments
    I’m really excited to get to present at another SQL Saturday event -- this time in Boston! I really enjoyed the events in Redmond , and I’m looking forward to presenting two sessions this time around. In the morning I’ll be co-presenting SSIS – The New...
  • SSIS Team Blog

    SQL Server Customer-Ready videos on Channel 9

    • 0 Comments
    Channel 9 has posted a series of videos that talk about what’s coming up in SQL Server Denali. These short (< 10 minutes each) videos are done by members of the engineering team, and are meant to give customers a peek into the goals and visions on...
  • SSIS Team Blog

    Learn SQL Server 2008 R2 Integration Services Now

    • 1 Comments
    The Data Platform Evangelism team has published the third unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a SQLInsights) on MSDN. The SQL Server 2008 R2 Business Intelligence Training Course (SQLInsights) will help you learn...
  • SSIS Team Blog

    How do I log to multiple locations?

    • 2 Comments
    Problem: I want all errors in my package to be reported to the Windows Event Log, and all other events to be logged to SQL Server. Logging all messages to multiple locations is pretty simple. On the Configure SSIS Logs dialog (SSIS –> Logging …), you...
  • SSIS Team Blog

    Tech Ed 2011 – Session Preference Survey

    • 0 Comments
    There is a Session Preference survey up on the Tech Ed North America 2011 site . This is a great way to provide input to the session selection committee. If you plan on attending Tech Ed NA, be sure to fill it out before the survey closes (February 17th...
  • SSIS Team Blog

    Why does my package run slower in BIDS than DTEXEC?

    • 1 Comments
    Jamie Thomson recently suggested that you should run your packages using DTEXEC when doing performance testing, as it (typically) performs much better then when the same package is run in BIDS. If you haven’t already read it, go do that now. It has a...
  • SSIS Team Blog

    LEFT Function in SSIS Expressions

    • 7 Comments
    There are a number of small changes to Integration Services in SQL Server Denali that might not be immediately apparent. One of these is the new LEFT function in the SSIS Expression language .   This new function provides a simpler way to get the...
  • SSIS Team Blog

    New and Improved Connectivity Wiki

    • 1 Comments
    We’ll soon be taking down the old connectivity wiki, and have moved all of the content to the new Technet Wiki Pages . You can find a full list of SSIS wiki pages here , or you can click through to the connectivity related pages linked below: SSIS 64...
  • SSIS Team Blog

    EzAPI - Update

    • 0 Comments
    I’ve just updated the Codeplex version of EzAPI – an alternative SSIS package creation API. If you missed the previous release , I definitely recommend checking it out. Updates include : Support for additional containers, tasks and components Bug fixes...
  • SSIS Team Blog

    SQL Server Denali Resource Center

    • 0 Comments
    Looking for more information on SSIS functionality in SQL Server Denali? Head over to the SQL Server Denali Resource Center . There are plenty of articles and links to community blog posts, as well as 12 videos about the new functionality in SSIS. Migration...
  • SSIS Team Blog

    SSIS Tips & Tricks

    • 0 Comments
    Steve Swartz’s SSIS Tips & Tricks session from TechEd Europe 2010 is available online . Be sure to check it out! SSIS 2008: Tips and Tricks Are you starting up a new project with SQL Server Integration Services? Do you want to speed up an existing...
  • SSIS Team Blog

    SQL Server Denali – What’s Coming Next in SSIS

    • 2 Comments
    Thanks to everyone who attended my session at SQL PASS yesterday. The recording of the session isn’t available yet, but thankfully, Steve Swartz, the Group Program Manager for the SSIS team, presented the same content about SQL Server Denali at TechEd...
  • SSIS Team Blog

    SQL PASS Summit 2010

    • 0 Comments
    Will you be attending PASS this year? I’ll definitely be there, along with most of the SSIS team! I’ll be presenting a talk about the next version of SSIS , and representing SSIS in the BI Power Hour . Be sure to swing by the product pavilion and Ask...
  • SSIS Team Blog

    Upcoming Product Changes

    • 10 Comments
    We’ve been hard at work on the next version of SQL Server, and it’s (almost) time to start sharing some of exciting new functionality we’ve introduced to SSIS. Over the new few months (starting about the time the first public CTP drops), I expect you...
  • SSIS Team Blog

    Speeding up Derived Column Transforms

    • 1 Comments
    A new technical note about splitting up transforms to increase performance has been posted on the SQLCAT site . It’s something you want to consider when you’re using synchronous transforms (like Derived Column, or Data Convert) to perform actions on a...
  • SSIS Team Blog

    Optimizing the Slowly Changing Dimension Wizard

    • 1 Comments
    As a follow-up to my previous post about SCD processing in SSIS , I thought I’d go deeper into using the built-in Slowly Changing Dimension Wizard . While there are definitely more efficient ways to do SCD processing in SSIS, there are some optimizations...
  • SSIS Team Blog

    String to Date conversion

    • 0 Comments
    This question recently came up on an internal SSIS mailing list: We’re converting date strings to date columns using the Derived Column transform. We’ve noticed some weird conversion behavior with older dates, like ‘0001-01-01’. It seems that year values...
  • SSIS Team Blog

    Bulk Report Generation using SSIS and SSRS 2008 R2

    • 0 Comments
    A new article on how to programmatically generate reports in large volumes using SSIS and SSRS has been published in the MSDN Library. It provides an interesting example of how to parameterize your reports, and drive the report generation using an SSIS...
  • SSIS Team Blog

    SSIS Configuration and Deployment Videos

    • 3 Comments
    We’ve been hard at work on the next version of the product for a while now. I should be able to talk more about our plans sometime in the fall, but until then I can say that configuration and deployment has been one of our focus areas. I’ve recently been...
  • SSIS Team Blog

    Performance Tuning SSIS (video)

    • 0 Comments
    Brian Knight's Performance Tuning SSIS talk from Tech Ed 2010 has been posted online . Performance Tuning Microsoft SQL Server Integration Services In this demo-rich presentation, learn some of the common and not so common ways to tune SQL Server...
  • SSIS Team Blog

    SSIS Performance Design Patterns (video)

    • 3 Comments
    The Performance Design Patterns talk I did at Tech Ed 2010 has been posted online . This is pretty much the same talk I gave at SQL Saturday #43 , so if you had attended and were looking for the slides, you can find them on the MS TechEd site. Enjoy...
Page 4 of 10 (242 items) «23456»