We help IT Professionals succeed at work.
Get Started

Error Message inside DTS Package

Last Modified: 2013-11-30
SQL Server Version: 2000

Hi, I am having some ODBC error messages when I try to open up DTS packages on our deveopment and production servers.  Nobody has been able to answer this question for me at work, so I'm hoping one of the experts here can!

I'm getting a few variations on this error...

Mind you, all these DTS packages are live and running just fine on the server and they open up properly for the other DBA... so, I'm assuming it has something to do with my computer...

When I double click on some of the objects inside of the DTS package I'm getting errors...they usually occur when the package is connecting to an external data source to pull in data.

The first message is:  Access Denied.  With just an OK button.  I click the OK button and then another error message pops up that says:  No provider is selected.  To continue, you must select a valid provider.  With just an ok button.  When you hit ok it does nothing.  (This occurs when I double click on the solid black line that is going from one object to the other.  If I click on the connection object, it just says access is denied and then brings up the connection window empty.

The second message I get (in a different DTS package):  Error Source: Microsoft OLE DB Provicer for ODBC Drivers  Error Description:  Microsoft ODBC Driver Manager Data source name not found and no default driver specified.  This occurs when I click on the solid black line that goes between the connection objects.  If I click on the connection object, it just says access denied and brings up the blank connection window as in the first scenerio.

I assume this has something to do with the providers/drivers I have installed on my desktop... but I can't figure out how to fix it.  I am running Windows XP and I cannot update the MDAC because it says I don't need to do it as my version of Windows has everything in it already.

Any thoughts?
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE