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 » SSIS » Integration Services   (RSS)
Showing page 2 of 3 (21 total posts)
  • PASS Summit 2010 – BI Workshop

    PASS Summit 2010 Pre & Post conference are out! This year I’ll deliver the “Creating BI Solution from A to Z” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional modeling and the creation of the Datawarehouse, the implementation of the ETL process with ...
    Posted to Davide Mauri (Weblog) by manowar on June 30, 2010
  • 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: 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 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
  • 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
  • Long life to TableDifference

    It seems that Microsoft will not improve the slow SCD component that is part of SSIS (at least, this is what I understand from this Microsoft Connect answer). This means that TableDifference has a long life because it will be useful even in SQL Server 2008. The versione 1.2 beta of TableDifference still needs some test because there is a latent ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 8, 2007
Privacy Statement