More errors after SP3... Re: Error in SQL 7.0 DTS, trying to access local packages
Thanks a lot for the reply. I had no clue where to search and this was of
This is exactly what I did:
First, I am not working on a clean install of NT so that may cause lots of
problems, unfortunately I have no control over that.
I installed SQL7's SP3 on my machine to be in synch with the server I wanted
to work off of. Then, after I did that, i was able to get to the
design view of my DTSs.
But after I rebooted, I wasn't able to get to Enterprise Manager anymore.
As a matter of fact, I get the infamous "Snap-in failed to initialize"
error message. And... I can't get into Query Analyzer, I get "The procedure
entry point SQLGUIGetOS could not be located in the dynamic link library
SQLGUI.dll". Then I tried to reapply SP6a (nothing changed) and MDAC 2.5
This machine I am working on has had potentially lost of things
installed/de-installed/ re-installed and I think it will not be possible
to get it re-staged now. However I may be able to get somebody to de-install
and reinstall SQL 7.0. Is there anybody who has ideas before I have to get
to the reinstall process? Please?
Thanks in advance,
"Euan Garden" <email@example.com> wrote:
>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.
>"Isabelle A. Melnick" <firstname.lastname@example.org> wrote in message
>> 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
>> 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
>> 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
>> in SQL, and even that didn't work. I need to get some work done on that
>> 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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL