Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DTS Standards


DTS Standards

Author
Message
Jonathan Stokes
Jonathan Stokes
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1051 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!
Edward W. Stanley
Edward W. Stanley
Mr or Mrs. 500
Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)Mr or Mrs. 500 (568 reputation)

Group: General Forum Members
Points: 568 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.





Jonathan Stokes
Jonathan Stokes
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1051 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!
Alex-217289
Alex-217289
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 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
philcart
philcart
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3570 Visits: 1436

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
Carlos Urbina
Carlos Urbina
SSC-Enthusiastic
SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)

Group: General Forum Members
Points: 146 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search