March 23, 2011 at 6:49 am
Hello,
How to find DTS packages in sql server 2000? I was told I need to re write them in order to convert to SQL Server 2005, any suggestions??
Thank you
March 23, 2011 at 7:24 am
There is an add-on you can get that would allow you to veiw them directly in SMS for 2005. The add-on can be found in
The file you are looking for is as follows.
Microsoft SQL Server 2000 DTS Designer Components
The Microsoft SQL Server 2000 Data Transformation Services (DTS) package designer is a design tool used by developers and administrators of SQL Server 2005 servers to edit and maintain existing DTS packages until they can be upgraded or recreated in the SQL Server 2005 Integration Services package format. After installing this download, SQL Server 2005 users can continue to edit and maintain existing DTS packages from the Object Explorer in SQL Server 2005 Management Studio and from the Execute DTS 2000 Package Task Editor in Business Intelligence Development Studio, without needing to reinstall the SQL Server 2000 tools. The DTS package designer in this download was formerly accessed from the Data Transformation Services node in SQL Server 2000 Enterprise Manager.
Audience(s): Customer, Developer
X86 Package (SQLServer2005_DTS.msi) - 5083 KB
Once you get that install connect using SMS and then in the Object explorer DTS packages are found under Management\Legacy\Data Transformation Services
You can veiw the DTS packages in that location currently but with out the add-on you will not be able to open them.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply