• Good article, although I agree with darren.green, its the DTS Object model that reveals all.

    I like your use of the EnumPackageInfos functionality. A number of people don't know about these extra bits. Pity there isn't much info to be found about how to use them effectively.

    Also, it would be worth noting that after running your script, all the packages would be set to connect to the server using SQL Security. Therefore if you have the server setup to Windows Only, not only will you get an error when you save the package, you won't get any logs either!

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface