dbTalk Databases Forums  

Transfer objects between SQL Servers fails

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Transfer objects between SQL Servers fails in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marcelo Coimbra
 
Posts: n/a

Default Transfer objects between SQL Servers fails - 10-16-2003 , 10:03 AM






Using DTS Wizard there is an option wich allows me to
select the objects i desire to import but when i click
that button ("select objects") i got a message error from
Dr.Watson ("dtswiz.exe").

I'm using Windows 2000(BR)Pro SP4, and SQL Server v7.00.623

Thanks!

Reply With Quote
  #2  
Old   
Ryan Waight
 
Posts: n/a

Default Re: Transfer objects between SQL Servers fails - 10-16-2003 , 10:10 AM






Suggest applying the latest service pack for SQL 7.

SQL Server v7.00.623 is SQL7 as it shipped with no SP.

Current SQL7 Service Pack is 4 i beleive, taking the version to v7.00.1063

--
HTH

Ryan Waight, MCDBA, MCSE

"Marcelo Coimbra" <mcoimbrac (AT) yahoo (DOT) com> wrote

Quote:
Using DTS Wizard there is an option wich allows me to
select the objects i desire to import but when i click
that button ("select objects") i got a message error from
Dr.Watson ("dtswiz.exe").

I'm using Windows 2000(BR)Pro SP4, and SQL Server v7.00.623

Thanks!



Reply With Quote
  #3  
Old   
Marcelo Coimbra
 
Posts: n/a

Default Re: Transfer objects between SQL Servers fails - 10-16-2003 , 10:45 AM



And if i say i also got an error message when i try to aply any
distribution of the SP for SQL Server?

When i start the setup.bat file provided within the SP or even when i
use 'SQL Server Upgrade Wizard' i receive an error message which tells
me that "The DLL kernel32.dll were realocated in memory. The program
will not run properly. The realocation occurs because the DLL
C:\WINNT\system32\MPR.dll used a DLLs Windows system reserved adress."
And next another messages "A service control operation failed for the
MSSQLServer service: 128" and "Setup was unable to verify the state of
the server for an upgrade. Verify the server is able to start, you are
able to connect, and restart setup".

Note: My SQL Server works perfectly.

The first error message i wrote may be not exactly as it should appears
in an english version.


Thanks again!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.