DTS Designer Error

  • Hello,

    I've recently installed sql server 2000 on my home computer. I can create databases, but am having an issue with the dts package designer.

    When I try to create a new SQL Server connection I get the following DTS Error:

    "No provider exists for this connection on this computer".

    I probably didn't set something up right, but I can't seem to find the answer.

    Any thoughts would be helpful.

    Thank you.

  • - also upgrade to sp4.

    - what kind of connections did you allow for sqlserver

      (sqlserver serverproperties network-config)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply