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

difference between DTS and SSIS.

  
   Database Forums (Home) -> Client RSS
Next:  Unspecified System Error = -21005. (State:S1000, ..  
Author Message
Smith

External


Since: Jan 22, 2008
Posts: 17



(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: Nov 21, 2007
Posts: 82



(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: Aug 29, 2007
Posts: 192



(Msg. 3) Posted: Wed Jan 23, 2008 3:01 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" wrote in message

> 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:
problem deploying access project - I have given a copy of my access project to user. This was developed in Access 2003 in Access 2000 file format. User PC is running Access 2000 ( 904402 SR-1). The problem seems to be that Functions are not visible to thic client so queries and forms..

Why the table is locked ? - Dear all, I have Access Font End to SQL server Back end. In an Access form, I use combobox, based on a stored procedure, which based on 1 table (SELECT LocationID, LocationDescription FROM Locations). When I open the form and check in the SQL server....

SQL problem pls help - I have installed Visual Studio 2005 beta 2 that include the SQL Express. Then I installed the SQLClient to my pc too. And when I click on the sql group An error message pops up "A connection could not be established to Computername\sqlexpress. ....

enterprise manager error - Hi, When trying to modify or add a table using enterprise manager I got this message error: Enterprise manager: not enough storage is available to complete this operation. I have a lot off space available. I don't have a memory leake. My server is..

Windows XP SP2 can't connect to SQL server - We have a problem at one site, a new server (2003 SBS & SQL server) has recently been installed, all the clients are Windows XP with SP2, none of them can connect to the SQL server, the error they get on testing the connection is to check the user...
   Database Forums (Home) -> Client All times are: Pacific Time (US & Canada)
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 ]