| Author: UltimateRengan 26 Aug 2008 | Member Level: Diamond | Rating:  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 2008 | Member Level: Diamond | Rating:  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 2008 | Member Level: Diamond | Rating:  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 2008 | Member Level: Diamond | Rating:  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
|