C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

Difference Between SSIS and DTS


Posted Date: 26 Aug 2008      Posted By: satish kumar thota      Member Level: Gold     Points: 1   Responses: 5



What is the Difference Between SSIS and DTS




Responses

Author: UltimateRengan    26 Aug 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 5

hi,
http://www.mydatabasesupport.com/forums/sqlserver-dts/246697-dts-vs-ssis.html
http://sql-server-performance.com/Community/forums/p/23006/131079.aspx
http://searchsqlserver.techtarget.com/loginMembersOnly/1,289498,sid87_gci1167697,00.html?NextURL=http%3A//searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0%2C289625%2Csid87_gci1167697%2C00.html
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3792508&SiteID=1


i hope this may help u

Advance Happy Diwali
SAP B1



Author: Sridhar R    26 Aug 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 5

Verify these links..This may give u an idea..

http://searchsqlserver.techtarget.com/loginMembersOnly/1,289498,sid87_gci1167697,00.html?NextURL=http%3A//searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0%2C289625%2Csid87_gci1167697%2C00.html
http://www.mydatabasesupport.com/forums/sqlserver-dts/246697-dts-vs-ssis.html
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3792508&SiteID=1

Regards
Sridhar R
Nothing is illegal, Until You Get Caught
With Tears...Sridhar R



Author: D.Jeya kumar(JK)    26 Aug 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 6

Hi,


SSIS is new in Sql server 2005. previously DTS package is used for this purpose.now it is replace with SSIS

I think SSIS(Sql server Integration service) is completly changed in sql server 2005 and 2008. DTS (Data Transformation service) is a brought from ETL and now it is replaced by SSIS in sql server 2005.

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clients/2008-01/msg00016.html


http://msdn.microsoft.com/en-us/library/bb332055.aspx

http://groups.google.com/group/microsoft.public.sqlserver.clients/browse_thread/thread/b11da0a850713230

Regards
JK



Author: Balthazor    27 Aug 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 5

Just have a look on this.

this will be enough to get general idea

decipherinfosys.wordpress.com/2008/03/11/dts-vs-ssis-a-basic-overview/

sql-server-performance.com/Community/forums/p/23006/131079.aspx

orums.microsoft.com/msdn/ShowPost.aspx?PostID=3792508&SiteID=1

www.sqljunkies.com/WebLog/15996.aspx

pragmaticworks.com/.../archive/2008/03/12/ssis-lab-runtime-performance-differences-between-dts-and-ssis.aspx

www.mydatabasesupport.com/forums/sqlserver-dts/246697-dts-vs-ssis.html

Regards,
Balthazor



Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : Data Modeling
Previous : Give stored procedure
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use