dbTalk Databases Forums  

cannot open dts

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


Discuss cannot open dts in the microsoft.public.sqlserver.dts forum.



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

Default cannot open dts - 06-04-2004 , 02:55 AM






hi sql experts!
my PC has been reformatted. i am accessing a SQL7.0
databases. before my PC is reformatted i can view and edit
all DTS packages. and now, i have SQL7.0 back installed on
it but now it cannot open any dts and gives me an error
something like 'the parameter is incorrect'. what is
wrong? do i need to install enything extra to make it work?

appreciate yr help.its urgent. thank u!!
azimah-k.lumpur.

p/s: pls cc to hameiza (AT) hotmail (DOT) com as well.

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: cannot open dts - 06-04-2004 , 03:34 AM






Maybe you are seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
hi sql experts!
my PC has been reformatted. i am accessing a SQL7.0
databases. before my PC is reformatted i can view and edit
all DTS packages. and now, i have SQL7.0 back installed on
it but now it cannot open any dts and gives me an error
something like 'the parameter is incorrect'. what is
wrong? do i need to install enything extra to make it work?

appreciate yr help.its urgent. thank u!!
azimah-k.lumpur.

p/s: pls cc to hameiza (AT) hotmail (DOT) com as well.



Reply With Quote
  #3  
Old   
azimah
 
Posts: n/a

Default Re: cannot open dts - 06-04-2004 , 04:08 AM



thanks allan!
but then how do i check the current service pack for SQL i
am having on my PC as well as on the server itself? (to
check the compatibility)
pls reply. thanks again.

azimah

Quote:
-----Original Message-----
Maybe you are seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1815501c44a09$4bfeb000$a501280a (AT) phx (DOT) gbl...
hi sql experts!
my PC has been reformatted. i am accessing a SQL7.0
databases. before my PC is reformatted i can view and
edit
all DTS packages. and now, i have SQL7.0 back installed
on
it but now it cannot open any dts and gives me an error
something like 'the parameter is incorrect'. what is
wrong? do i need to install enything extra to make it
work?

appreciate yr help.its urgent. thank u!!
azimah-k.lumpur.

p/s: pls cc to hameiza (AT) hotmail (DOT) com as well.


.


Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: cannot open dts - 06-04-2004 , 04:12 AM



In QA on both boxes you can issue

SELECT @@version.


You can then use this to determine your versions

http://vyaskn.tripod.com/sqlsps.htm
--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
thanks allan!
but then how do i check the current service pack for SQL i
am having on my PC as well as on the server itself? (to
check the compatibility)
pls reply. thanks again.

azimah

-----Original Message-----
Maybe you are seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1815501c44a09$4bfeb000$a501280a (AT) phx (DOT) gbl...
hi sql experts!
my PC has been reformatted. i am accessing a SQL7.0
databases. before my PC is reformatted i can view and
edit
all DTS packages. and now, i have SQL7.0 back installed
on
it but now it cannot open any dts and gives me an error
something like 'the parameter is incorrect'. what is
wrong? do i need to install enything extra to make it
work?

appreciate yr help.its urgent. thank u!!
azimah-k.lumpur.

p/s: pls cc to hameiza (AT) hotmail (DOT) com as well.


.




Reply With Quote
  #5  
Old   
azimah
 
Posts: n/a

Default Re: cannot open dts - 06-04-2004 , 04:34 AM



ok, got it.
one last question, how do i check my sp version on my
local PC? do i need to make it as a server first? how do i
do that?
thanks allan!

Quote:
-----Original Message-----
In QA on both boxes you can issue

SELECT @@version.


You can then use this to determine your versions

http://vyaskn.tripod.com/sqlsps.htm
--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1813c01c44a13$7a6ca0f0$a401280a (AT) phx (DOT) gbl...
thanks allan!
but then how do i check the current service pack for
SQL i
am having on my PC as well as on the server itself? (to
check the compatibility)
pls reply. thanks again.

azimah

-----Original Message-----
Maybe you are seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1815501c44a09$4bfeb000$a501280a (AT) phx (DOT) gbl...
hi sql experts!
my PC has been reformatted. i am accessing a SQL7.0
databases. before my PC is reformatted i can view and
edit
all DTS packages. and now, i have SQL7.0 back
installed
on
it but now it cannot open any dts and gives me an
error
something like 'the parameter is incorrect'. what is
wrong? do i need to install enything extra to make it
work?

appreciate yr help.its urgent. thank u!!
azimah-k.lumpur.

p/s: pls cc to hameiza (AT) hotmail (DOT) com as well.


.



.


Reply With Quote
  #6  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: cannot open dts - 06-04-2004 , 04:42 AM



Have you installed SQL Server on your PC?

If yes then it is no different



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
ok, got it.
one last question, how do i check my sp version on my
local PC? do i need to make it as a server first? how do i
do that?
thanks allan!

-----Original Message-----
In QA on both boxes you can issue

SELECT @@version.


You can then use this to determine your versions

http://vyaskn.tripod.com/sqlsps.htm
--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1813c01c44a13$7a6ca0f0$a401280a (AT) phx (DOT) gbl...
thanks allan!
but then how do i check the current service pack for
SQL i
am having on my PC as well as on the server itself? (to
check the compatibility)
pls reply. thanks again.

azimah

-----Original Message-----
Maybe you are seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"azimah" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1815501c44a09$4bfeb000$a501280a (AT) phx (DOT) gbl...
hi sql experts!
my PC has been reformatted. i am accessing a SQL7.0
databases. before my PC is reformatted i can view and
edit
all DTS packages. and now, i have SQL7.0 back
installed
on
it but now it cannot open any dts and gives me an
error
something like 'the parameter is incorrect'. what is
wrong? do i need to install enything extra to make it
work?

appreciate yr help.its urgent. thank u!!
azimah-k.lumpur.

p/s: pls cc to hameiza (AT) hotmail (DOT) com as well.


.



.




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.