I am trying to create a DTS package using SQL Server 2008. I just want to be able to test a DTS package since I don't have a development environment, so right now my laptop is the development environment. I am not a SQL Server DBA, just wanted to state that so everyone is clear. I have followed the directions listed here: http://msdn.microsoft.com/en-us/library/ms143755.aspxEven after doing everything listed in the directions, I still can't see where I can create a new DTS package in SQL Server Management Studio. Is there something that I am missing here? However,after

You can't create new DTS packages in SQL Server 2008 - DTS (Data Transformation Services) is deprecated (discontinued).The technology that replaces it is SQL Server Integration Services (SSIS). Visit JumpstartTV.com, or MSDN's Integration Services portal for some "starter" videos/info.

Thank you!

Here is the solution that worked with SQL Server 2008 R2 (without SQL Server 2000) on Server Machine (with Windows Server 2008, 64 bit). 1. Install SQL Server 2008 2.Install SQL Server DTS Designer (SQLServer2005_DTS.msi) 3.Install SQL Server backward compatibility (SQLServer2005_BC_x64.msi) 4. Check the patch ‘C:\Program Files (x86)\Microsoft SQL Server\80\Tools \Binn\’ in Environment variables and put it at the beginning. 5. Repair SQL Server backward compatibility (SQLServer2005_BC_x64.msi) 6. Install SQL Server DTS Designer (SQLServer2005_DTS.msi) Again. Steps to Import DTS in SQL Server 2008 R2. 1. Open SSMS 2008 R2, Management , Legacy , Data Transformation Services. 2. Right click on Data Transformation Services , Select "Open Package file .." and select the Structure File of DTS to import. This will give error but will show the objects (white boxes and arrows) see below picture. (Embedded image moved to file: pic31449.gif) 3. Right click on each object (no matter it appears or not, once clicked then it appears), select properties. Once window opens (change/no change) , select OK. Object will appear properly. (Embedded image moved to file: pic23038.gif) 4. Select Package-Save as and save in SQL Server with same name as structured file. 5. Close the window of DTS. 6. Go to Management , Legacy , Data Transformation Services, Recently saved DTS. Right click on it and select "Open..". This will open the DTS perfectly fine without error.