THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Integration Services   (RSS)
Showing page 2 of 4 (32 total posts)
  • SSIS Expression Tester Tool

    Thanks to my friend's Doug blog I’ve found a very nice tool made by fellow MVP Darren Green which really helps to make SSIS develoepers life easier: http://expressioneditor.codeplex.com/Wikipage?ProjectName=expressioneditor In brief the tool allow the testing of SSIS Expression so that one can evaluate and test them before using in SSIS ...
    Posted to Davide Mauri (Weblog) by manowar on June 13, 2010
  • SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

    When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2 project. SSIS editor doesn't offer a way to set ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 13, 2010
  • 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 http://dtloggedexec.codeplex.com/releases/view/44689 Here’s the release notes: FIRST ...
    Posted to Davide Mauri (Weblog) by manowar on May 9, 2010
  • DTLoggedExec 0.2.3.0 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 0.2.3.0 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 0.2.3.0 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 http://tinyurl.com/5oykgj Thanks to all who attended!
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on October 17, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement