dts packages

hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KPHave a look at
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KP|||Hi,
If there are not many packages, you can open them individually and do a
'package| Save as ' pointing to the SQL2000 server.If not, try to transfer
the packages directly between
sysdtspackages(http://www.sqldts.com/main.asp?nav=1,6,204,0)
Also, you can use a tool called ScriptPkg which is present in the SQL Server
setup CD.This tool can script your packages to VB code which can be then
executed against SQL2000.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
> hi
> I have my database & dts packages are on sql 7.0 with
> windows nt4.0. I am moving the database to sql 2000.
> Database part I am quite sure how to proceed. How do I go
> about moving or for that matter to copy the dts packages
> to sql 2000. any help in this regard is appreciated
> thanks
> KP