Monday, March 12, 2012

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

No comments:

Post a Comment