SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Overview of DTS Packages


Overview of DTS Packages

Author
Message
Rama Nageshwara Rao
Rama Nageshwara Rao
SSC-Enthusiastic
SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)

Group: General Forum Members
Points: 113 Visits: 13
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rNageshwara/overviewofdtspackages.asp
John Scarborough
John Scarborough
Mr or Mrs. 500
Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)

Group: General Forum Members
Points: 528 Visits: 52
Nice basic (but detailed) article. Very good and well worth reading for someone not experienced in DTS.

John Scarborough
MCDBA, MCSA
david russell-253790
david russell-253790
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1580 Visits: 1

I am certainly confused. DTS has been replaced with SSIS in SQL Server 2005 which just became available to the public on Monday. There are hundreds of reasons why SSIS is considered a new product, historically to replace DTS. It is a bit hard to understand why anyone would start using this technology now.

The article itself was well done; but it would be much more enlightening for it to have been in today's technology.




Cheers,

david russell

Jason Striker
Jason Striker
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 2

When I had to add a data exporting tool to a program I'm working on, a co-worker suggested I use DTS. To make a long story short, I looked into it and decided it wouldn't work for my particular situation.

That being the case, while I was cleaning out my inbox, an article in the SQL Server Central newsletter about DTS is something that definitely catches my attention.

However, when I start reading:

"Many organizations need to centralize data to improve corporate decision-making. However, their data may be stored in a variety of formats and in different locations. Data Transformation Services (DTS) addresses this vital business need by providing a set of tools that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations supported by DTS connectivity..."

...I get pissed. Deja vu, anyone? Hell yeah, I just read that word for word last week from the SQL Server Help article "DTS Basics"

Next time you decide to include text from someone else's work in your own, the very least you should do is to give them credit. Not doing so is called "plagiarism". Look it up.


BigAl-583926
BigAl-583926
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 9
UnsureGreat article but I have a specific question not covered within. I have written a DTS package to be scheduled to run nightly to synchronize two databases. I have written a query which runs fine bar 1 thing. I have included a constant field ie 'S' as [Record Type]in the SELECT clause, to flag the data from the DTS package. When I run the query in Query analyzer or in the DTS preview the constant field shows up fine but when I check the upload table that field is missing. Can anyone help. What difference does the constant value make. Thank you community in anticipation. BigAl
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