Opening DTS packages on a 2008 SQL Server requires several steps to be able to view the packages in a DTS designer. Here’s a link to these steps on a 32-bit machine or on a 64-bit machine. After following these step you will be able to open your DTS packages in the DTS Designer.
These steps are great for opening DTS packages but I ran into a problem recently where I was not able to import packages on my server which shouldn’t require as many prerequisites like opening packages does.
When I attempted to import a package I received the following error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Microsoft OLE DB Provider for SQL Server)
After doing some research I found the problem in a blog by Xinwei Hong. He has several possible problems listed, which luckily was solved by his first solution. It is was a simple fix and here are the steps I followed to fix my problem:
1. Open the SQL Server Configuration Manager
2. Expand on SQL Server Network Configuration and select Protocols for MSSQLSERVER
3. Enable TCP/IP. Not sure why this was disabled to begin with but that was my problem