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?
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?
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.