InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:29:37 GMT20http://www.sqlservercentral.com/Forums/Topic234662-239-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/cherring/dtsstandards.asp">http://www.sqlservercentral.com/columnists/cherring/dtsstandards.asp</A>Wed, 02 Nov 2005 14:08:00 GMTJonathan Stokeshttp://www.sqlservercentral.com/Forums/Topic198264-239-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/cherring/portabledtspackages.asp">http://www.sqlservercentral.com/columnists/cherring/portabledtspackages.asp</A>Thu, 07 Jul 2005 11:59:00 GMTJonathan Stokeshttp://www.sqlservercentral.com/Forums/Topic206624-239-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/cherring/singlepointofadministration.asp">http://www.sqlservercentral.com/columnists/cherring/singlepointofadministration.asp</A>Tue, 02 Aug 2005 13:54:00 GMTJonathan Stokeshttp://www.sqlservercentral.com/Forums/Topic238623-239-1.aspx<P>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.</P><P>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".</P><P>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.</P><P>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.</P>Mon, 21 Nov 2005 12:02:00 GMTRobert Davishttp://www.sqlservercentral.com/Forums/Topic206272-239-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/cherring/administeringadevelopmentenvironment.asp">http://www.sqlservercentral.com/columnists/cherring/administeringadevelopmentenvironment.asp</A>Mon, 01 Aug 2005 14:51:00 GMTJonathan Stokes