Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: Connection objects are not available in DTS Designer

    Problem Description: The following error is popping up and not allowing opening or running any of the DTS packages. Connection objects are not available in DTS Designer.

    "Error in the DLL"
    "Need to run the object to perform this operation"

    We have reinstalled the MS SQL Server 2000 Standard Edition with Service pack 3 and MSO3031 hot fix. Still the issue continues.
    Operating System:Windows 2000

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You really should open up an MS ticket for this. It's $250. They don't charge you if it's actually their issue. Are there any other errors in the application, system, or SQL Server error logs?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Oct 2004
    Posts
    2
    Thanks For you help
    This seems to be related to MDAC issue. Latest MDAC 2.8 was resolved the problem but it is not clear why the MDAC 2.7 was created the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •