Blog - Title

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

    Data Integration at Microsoft: Technologies and Solution Patterns (video)

    • 1 Comments
    Another talk at the MS BI Conference that I really found useful was Jeff Bernhardt’s talk about the different data integration technologies at Microsoft . Data Integration at Microsoft: Technologies and Solution Patterns There are many reasons to contemplate...
  • SSIS Team Blog

    Beyond Scripting presentation available online

    • 1 Comments
    One of the sessions I did at the MS BI Conference last week is now available online at msteched.com . Beyond Scripting: Developing Reusable Extensions for Microsoft SQL Server Integration Services Have you written scripts for your ETL process that you...
  • SSIS Team Blog

    Handling HRESULT 0xC020402D from BufferManager.FindColumnByLineageID

    • 0 Comments
    While developing some custom transforms for my talks at the BI Conference next week , I hit a problem where I was getting an a failed HRESULT (COM Exception) in my PreExecute () method on a call to BufferManager.FindColumnByLineageID (). HRESULT 0xC020402D...
Page 4 of 10 (239 items) «23456»