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

RE: Expand / Collapse
Author
Message
Posted Monday, November 21, 2005 12:02 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:16 AM
Points: 1,612, Visits: 1,537

This is good for small packages. Adding text for every step would be overwhelming in a large package such as is typical in my organization.

Other than MailFailure, the names in the package still would not make a lot of sense to an outside viewer. To make it easier to read, use user friendly names like "Destination Production Table" and "Import Source" rather than "dstProdTable" and "impSource".

The text "All failures come back to here" in this sample is incorrect. The MailFailure step will be triggered to run if, and only if, the impSource fails. Each individual step should have its own MailFailure step.

If you are going to use a Dynamic Properties Task, you should set up a precedent to ensure that it runs before the task that needs to have this property set. This is especially important as your task get larger. If you have several tasks running simultaneously, DTS may force your Dynamic Properties task to wait while it runs other tasks, and by the time it runs, it may be too late. Don't assume that it's going to run before the task that needs it does.





My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #238623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse