Error in SQL 7.0 DTS, trying to access local packages


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Error in SQL 7.0 DTS, trying to access local packages

  1. #1
    Isabelle A. Melnick Guest

    Error in SQL 7.0 DTS, trying to access local packages


    Hi,

    I believe I posted this in the wrong discussion group this morning,
    enterprise.sql, sorry for the redundancy.

    We're on NT, using 7.0. Not sure of any service pack(s).

    I was wondering if anybody has seen this before. I can't find info on it
    on Microsoft's knowledge base and/or MSDN online, etc. Or I am not looking
    at the right place?!

    When I view the list of DTS packages on the server, I have no trouble.
    If I pick one DTS package and try to right click and select "Design Package",
    I get a weird error. Actually, everybody on my network
    gets this error unless they go on the server itself:

    "Error Source: Microsoft Data Transformation Services (DTS) package
    Error Description: The parameter is incorrect"

    I'm not a DBA but I suspect the problem may not be where we think it is,
    at least maybe not in the DB. The DBA made sure I had appropriate permissions
    in SQL, and even that didn't work. I need to get some work done on that machine
    and don't want to freeze myself to death in the server room. Anyone seen
    this before?

    Anyone has an idea on where I should start looking?

    Thanks in advance,

    Isabelle A. M.
    imelnick@sprintmail.com

  2. #2
    Euan Garden Guest

    Re: Error in SQL 7.0 DTS, trying to access local packages

    The packages were created with a version of SQL Server later than the one
    you were using, ie either a service pack or a later build.


    You can either save packages with passwords which will work across all
    versions or upgrade all machines to the same service pack.

    -Euan

    "Isabelle A. Melnick" <imelnick@sprintmail.com> wrote in message
    news:3b826f3f$1@news.devx.com...
    >
    > Hi,
    >
    > I believe I posted this in the wrong discussion group this morning,
    > enterprise.sql, sorry for the redundancy.
    >
    > We're on NT, using 7.0. Not sure of any service pack(s).
    >
    > I was wondering if anybody has seen this before. I can't find info on it
    > on Microsoft's knowledge base and/or MSDN online, etc. Or I am not looking
    > at the right place?!
    >
    > When I view the list of DTS packages on the server, I have no trouble.
    > If I pick one DTS package and try to right click and select "Design

    Package",
    > I get a weird error. Actually, everybody on my network
    > gets this error unless they go on the server itself:
    >
    > "Error Source: Microsoft Data Transformation Services (DTS) package
    > Error Description: The parameter is incorrect"
    >
    > I'm not a DBA but I suspect the problem may not be where we think it is,
    > at least maybe not in the DB. The DBA made sure I had appropriate

    permissions
    > in SQL, and even that didn't work. I need to get some work done on that

    machine
    > and don't want to freeze myself to death in the server room. Anyone seen
    > this before?
    >
    > Anyone has an idea on where I should start looking?
    >
    > Thanks in advance,
    >
    > Isabelle A. M.
    > imelnick@sprintmail.com




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center