Import DTS package from SS2000 to SS2005? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import DTS package from SS2000 to SS2005?

Hi! I cannot understand how to import DTS Local packages from SQL Server 2000 to SQL Server 2005? And how to create new DTS Local Packages in SQL Server 2005?
DTS is replaced with SSIS (SQL Server Integration Services),http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp,http://msdn2.microsoft.com/en-us/library/ms143706.aspx &http://msdn2.microsoft.com/en-us/library/ms143716.aspx links fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
in SQL Server 2005 you call it Intergrated Service. which you can create them from SQL Server Business Intelligence Development Studio which comes from SQL Server 2005 there is a tool whcih you can convert. you can download this from microsoft site.
But my experience is you better create them from the start. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com
]]>