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

DTS Standards Expand / Collapse
Author
Message
Posted Wednesday, November 2, 2005 2:08 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, August 3, 2007 2:55 AM
Points: 928, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/cherring/dtsstandards.asp


------------------------------
The Users are always right - when I'm not wrong!
Post #234662
Posted Monday, November 21, 2005 7:30 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 3:50 PM
Points: 544, Visits: 43

I think thats great.  But with the waning support for DTS as I found in the release of 2005 (which bothers me, btw),  I wonder how we can migrate those over to 2005 with little effort.  I have in some of my deployments dozens of complex DTS packages.

And maybe its job rentention but I"d rather be movign on to making newer better faster projects then maintenance.

Cheers.




Post #238488
Posted Monday, November 21, 2005 8:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, August 3, 2007 2:55 AM
Points: 928, Visits: 1
I agree with you. However, there are a lot of Organisation's out there who will still be using 2000 2 or more years from now.

At least that is the impression that I have got from talking to colleagues and friends. For some it's the money, for others the amount of work involved and for the cautious, the risk. Being in a datawarehouse environment currently moving to an etl tool scenario, there's not much to be immediately gained from moving to 2005.



------------------------------
The Users are always right - when I'm not wrong!
Post #238551
Posted Monday, November 21, 2005 12:36 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 9, 2009 8:13 AM
Points: 75, Visits: 3
I agree that the naming convention should certainly be used to clearly identify sources and destinations as well as transform steps. As for using descriptive text at the top of your DTS packages, perhaps consider hiring a DBA capable of making a couple of clicks to find out info instead. It'll keep your packages cleaner and many of the objects in DTS are self-describing anyway. With a good naming convention, you should be all set.

By the way, the Green Lantern rocks!



Cheers,

Alex


Rogue DBA
Post #238632
Posted Monday, November 21, 2005 2:59 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:06 PM
Points: 2,693, Visits: 1,202

Like the naming convention, just hate it when you look at the package and can't see the full name because of those annoying dots.

I avoid using text annotations and worrying too much about the package layout. Both of these are not part of the package object model so if you modify the package programmatically and save it you lose them.

Also, is the Execute Proces task just used to make a copy of the Excel file? The line "...import the source spreadsheet before we DTS it in..." sort of implies that we're importing the file twice.

 



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 #238674
Posted Tuesday, November 21, 2006 8:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 31, 2007 8:22 AM
Points: 92, Visits: 1
Thank you for your suggestions, Jonathan. In the long run, standards and conventions are not for the brilliant innovator, but for the stalwart person who can keep an enterprise going. For the innovator, I would remind them that genius has ALWAYS been about the 90% perspiration. In other words, we must take the time to help others understand what we do, no matter what the circumstances, because in the end it will be cost effective to the enterprise to which we owe our living.
Post #324637
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse