Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Set logging properties for group of DTS packages Expand / Collapse
Author
Message
Posted Wednesday, October 3, 2007 11:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 4:59 PM
Points: 2,693, Visits: 1,204
Comments posted to this topic are about the item Set logging properties for group of DTS packages

Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #406327
Posted Wednesday, November 21, 2007 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 3, 2011 4:24 PM
Points: 2, Visits: 39
Thanks to "Phill" for the example code, but be observant of his note:

NOTE: As the package is being modified programmatically, you will lose any text annotations and layout previously applied. Unfortunately there is no way to modify the package outside the DTS Designer and maintain these items.


This means that script will save the DTS package with the "Auto Layout" option applied. If you have spent any time arranging package steps in the designer, it will be lost.
Post #424573
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse