Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

difference between DTS and SSIS.

  
   Database Help (Home) -> Client RSS
Next:  SQL: numeric sort of a varchar field  
Author Message
Smith

External


Since: Jan 22, 2008
Posts: 16



(Msg. 1) Posted: Tue Jan 22, 2008 12:22 pm
Post subject: difference between DTS and SSIS.
Archived from groups: microsoft>public>sqlserver>clients (more info?)
Hi Professional,

What are difference between DTS and SSIS.

Thanks

 >> Stay informed about: difference between DTS and SSIS. 
Back to top
Login to vote
Sean McCown

External


Since: Jan 23, 2008
Posts: 60



(Msg. 2) Posted: Wed Jan 23, 2008 7:16 am
Post subject: RE: difference between DTS and SSIS. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You'll have to be more specific than that. SSIS is a completely different
product. It has none of the original DTS code in it. It has .NET integrated
and it makes tons of things easier than they were in DTS.

Just a couple things are looping through files and folders is much easier,
and error handling is more robust.

There are too many differences to note here, but if you have any specific
questions I'll see what I can do.

"Smith" wrote:

> Hi Professional,
>
> What are difference between DTS and SSIS.
>
> Thanks

 >> Stay informed about: difference between DTS and SSIS. 
Back to top
Login to vote
Ekrem_Önsoy

External


Since: Jan 11, 2008
Posts: 243



(Msg. 3) Posted: Wed Jan 23, 2008 9:11 pm
Post subject: Re: difference between DTS and SSIS. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hello Smith,

It seems you are confused about these terms... I just wanted to make a very
simple comment, so you'll understand what's what.

DTS is an acronym that stands for Data Transformation Services which is used
in SQL Server 2000. SSIS means SQL Server Integration Services which is said
almost completely rewritten for SQL Server 2005 and the successor of DTS
that is in SQL Server 2000.

SSIS Enhancements:
http://msdn2.microsoft.com/en-us/library/ms170781.aspx

You can learn more about the SSIS from the following link:
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

--
Ekrem Önsoy



"Smith" <naissani.RemoveThis@hotmail.co> wrote in message
news:82D2D9FF-1908-4709-8484-695D64AF1AC0@microsoft.com...
> Hi Professional,
>
> What are difference between DTS and SSIS.
>
> Thanks
 >> Stay informed about: difference between DTS and SSIS. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
OLEDB: Prepared cmd with NULL input param for NOT NULL INT.. - Provider: SQLOLEDB Version: SQL Server 2000 8.00.760 Script for creating table: CREATE TABLE [dbo].[ADRVERTRETER] ( <font color=purple> ; [ROWID] [timestamp] NULL ,</font> <font color=purple> ; [ROWVERTRETER] [int] NO...

[MS Design Tools] - Class not registered.&quot; - On a Windows 2000 pro workstation I am using SQL 2000 enterprise manager I am trying to return all rows, I get the error message "An unexpected error happened during this operation. [MS Design Tools] - Class not registered." I have reinstall...

Need help choosing front end for SQL Server - I've been working on an Access 97 database that's pretty much reached it's limit in terms of performance and reliability. Although it supports relatively few users (5-10 concurrent) it contains a lot of data (around 30 tables, some with several million..

SQL server tables read-only to ADP - I have successfully migrated an Access 2003 database to SQL server - at least all the tables and queries that resolve into views migrated successfully. I also sucessfully migrated all my forms and code into an ADP project. Everything works with one..

Opening table in SQL Server 2005? - This ought to be easy. But I can't figure out how to do it. Using Enterprise Manager in SQL Server 2000, I point to a table, select it, right click and choose Open Table-> Return all rows. Now I have the table open and I can edit to my heart's..
   Database Help (Home) -> Client All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]