THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Integration Services   (RSS)
Showing page 2 of 3 (30 total posts)
  • DTLoggedExec 1.0 Stable Released!

    After serveral years of development I’ve finally released the first non-beta version of DTLoggedExec! I’m now very confident that the product is stable and solid and has all the feature that are important to have (at least for me). DTLoggedExec 1.0 Here’s the release notes: FIRST ...
    Posted to Davide Mauri (Weblog) by manowar on May 9, 2010
  • DTLoggedExec beta published!

    Finally today I found the time to publish the latest release of my DTLoggedExec tool. This is quite big release, since I have introduced two new events, LogStartPackageLoading and LogEndPackageLoading, that allows a Log Provider to intercept event related to package loading and not package execution. This is really helpful to debug those situation ...
    Posted to Davide Mauri (Weblog) by manowar on November 28, 2009
  • DTLoggedExec is coming….

    After showing DTLoggedExec at SQL PASS I had quite a lot (good) of feedback, and so I decided to pospone the release I was ready to deploy to the public, to introduce new features and the default reporting capabilities I also showed during my session. I worked hard and finally the new version is ready! Some bug fixed, added new events to ...
    Posted to Davide Mauri (Weblog) by manowar on November 23, 2009
  • A week in Seattle

    Tomorrow morning I’ll fly to Seattle for the usual PASS Community Summit. I’m really happy for the next week. Even if this period is really full of work and a week away means that at my return I’ll have *really* busy times, the PASS Conference is always a nice break: meeting old and new friends, learning new things, enjoying beers and cocktails ...
    Posted to Davide Mauri (Weblog) by manowar on October 30, 2009
  • SET IDENTITY_INSERT little bug(?)

    While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create my packages. I’ve found that, when working on an empty table that has an identity column, if ...
    Posted to Davide Mauri (Weblog) by manowar on September 30, 2009
  • SSIS Package Parameters

    With the latest release of DTLoggedExec, I’ve also added a nice functionality to make package runtime configuration a little easier, introducing the concept of “Package Parameters”. I’ve now updated the documentation adding details on how to use this new feature (is *really* easy, but is *really* useful) and, as usual, you can find it on ...
    Posted to Davide Mauri (Weblog) by manowar on July 24, 2009
  • Use of the WITH clause in SQL Command SSIS OLEDB Source

    If you try to use the WITH clause in a SQL Command of an OLE DB Source in a Data Flow of Integration Services, you might receive the error 'Statement(s) could not be prepared'. Solution: put a semicolon (;) just before the WITH keyword.  
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 10, 2009
  • HDC08 Omaha Demos Posted

    Slides and demos for my hdc08omaha talks are now available for download from Thanks to all who attended!
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on October 17, 2008
  • The Top Five New Features in SSIS 2008 for Developers, Part 2

    Lookup. For many SQL Server Integration Services Developers, it's the transformation we most love to dislike - especially if you are using it against data living on remote server not on the same local network as the host running your package. This combination of circumstances sometimes drives us to some very inventive things. In this post I want ...
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on August 26, 2008
  • The Top Five New Features in SSIS 2008 for Developers, Part 1

    You have to give credit where credit is due, and I certainly have to give credit to Kirk Haselden et al and their book Microsoft SQL Server 2005 Integration Services. That book -- and some of trial and error -- taught me a lot about how to tune data flow tasks for better performance. The folks at Simple Talk have part of the book online ...
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on August 18, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement