Error in SQL 7.0 DTS, trying to access local packages

[Isabelle A. Melnick]

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

[Euan Garden]

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