Save DTS packages to MSDE

Hi,
I'm new to SQL Server. And I have problem moving the DTS packages from SQL server standard edition to MSDE. Is there other way to save the DTS package without access to the Enterprise Manager? And what about ways to edit the DTS packages loaded into MSDE so that it can run properly on the new server?
Thanks.Why not save the packages as files then you don't have any problems.

Does msde include the dts application?

Note that dts is a client application not part of the server.
It can load and run packages which may be stored in a database or in files and create connections to servers to manipulate data.|||The MSDE does come with the dtsrun utility.
So, you mean, if I save the DTS packages from SQL Server 2000 as .dts files, I can run the DTS packages from the .dts files? I think we have to save the .dts into the DTS service in MSDE first?

And another question that may arise is, how to edit the DTS package to make it run smoothly on another server without Enterprise Manager? Any suggestion?
Thanks...|||OK if the dts client is installed then you just need to load the package and run it.
The /F parameter on dtsrun will load the file and run it.

You can also use sp_oacreate which will allow you to change properties of the package before running it.
This will enable you to do anything you did with enterprise manager but not as easily. Save the package afterwards or you can use it to run the package and make any changes on every run.
Probably better to use it to set global variables and use them within the package.

see
www.nigelrivett.com
sp_oacreate Load DTS

Save $$$ on licensing?

SQL Server Developer edition does NOT have any limitations on connections,
users, or number of processors or CALS, correct? As long the database is no
t
used in a production environment.
Our mgmt has recently is ordering only ordering 1 Developer Edition license
for each new SQL database server we are installing. We have 15 servers on
order and each is a dual processor. This represents a huge cost savings of
not having to purchase per processor licenses as we had done in the past to
accomodate our users acceptance testing -- from thousands of dollars for eac
h
processor to less than $49 for each server.Would that really save you thousands even though you still buy the full
licences once you go live? I guess if you have a continuing UAT requirement
you will save something in the longer term. A worthy reminder about Dev
Edition anyway :-)
David Portas
SQL Server MVP
--

Save $$$ on licensing?

SQL Server Developer edition does NOT have any limitations on connections,
users, or number of processors or CALS, correct? As long the database is not
used in a production environment.
Our mgmt has recently is ordering only ordering 1 Developer Edition license
for each new SQL database server we are installing. We have 15 servers on
order and each is a dual processor. This represents a huge cost savings of
not having to purchase per processor licenses as we had done in the past to
accomodate our users acceptance testing -- from thousands of dollars for each
processor to less than $49 for each server.Would that really save you thousands even though you still buy the full
licences once you go live? I guess if you have a continuing UAT requirement
you will save something in the longer term. A worthy reminder about Dev
Edition anyway :-)
--
David Portas
SQL Server MVP
--

Save $$$ on licensing?

SQL Server Developer edition does NOT have any limitations on connections,
users, or number of processors or CALS, correct? As long the database is not
used in a production environment.
Our mgmt has recently is ordering only ordering 1 Developer Edition license
for each new SQL database server we are installing. We have 15 servers on
order and each is a dual processor. This represents a huge cost savings of
not having to purchase per processor licenses as we had done in the past to
accomodate our users acceptance testing -- from thousands of dollars for each
processor to less than $49 for each server.
Would that really save you thousands even though you still buy the full
licences once you go live? I guess if you have a continuing UAT requirement
you will save something in the longer term. A worthy reminder about Dev
Edition anyway :-)
David Portas
SQL Server MVP