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 (24 total posts)
  • Auto-Configuring SSIS Packages

    SSIS Package Configurations are very useful to make packages flexible so that you can change objects properties at run-time and thus make the package configurable without having to open and edit it. In a complex scenario where you have dozen of packages (even in in the smallest BI project I worked on I had 50 packages), each package may have its ...
    Posted to Davide Mauri (Weblog) by manowar on March 16, 2011
  • DTLoggedExec 1.1.2008.4 Released!

    Today I've relased the latest version of my DTExec replacement tool, DTLoggedExec. The main changes are the following: Used a new strategy for version numbers. Now it will follow the following pattern Major.Minor.TargetSQLServerVersion.Revision Added support for Auto Configurations Fixed a bug that reported incorrect number of errors ...
    Posted to Davide Mauri (Weblog) by manowar on March 15, 2011
  • 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
  • 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
Privacy Statement