Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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



Group: General Forum Members
Last Login: Thursday, December 1, 2016 6:49 AM
Points: 1,634, Visits: 1,621

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 MVP
Database Engineer at BlueMountain Capital Management
Post #238623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse