Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pkgal79
Starting Member
2 Posts |
 Posted - 2006-07-26 : 05:21:51
|
| I have SQL server with DTS jobs working fine on it. Now, it is required to configure same jobs at some other locations where only MSDE will be present. What could be the simpleset way to take existing .dts files and schedule them as job at MSDE. I have found some discussion on dtsrun.exe but it didnt work OR may be I am missing some steps. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-26 : 05:27:09
|
| Save your packages to files. Copy the package to the server which needs to run it. Schecule dtsrun commands to execute the packages.The packages will have to be built so that that they work on the other servers i.e. don't have hard coded server names, passwords, firectory names, ...==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
pkgal79
Starting Member
2 Posts |
Posted - 2006-07-26 : 06:09:09
|
| I have tried using dts run commands but it did not work. For example I copied following command in .bat file, but desired results could not achieved.DTSRUN.exe /S MyServer /N MyDTSPackageDo we have to define the path of DTSPackage or need to add .dts extension to it? Or there is some other problem?For info sake, the mentioned DTS package simply retrieves data from a single table and export it to a text file. For simplicity and testing purposes, I have defined the path format of a destination file as C:\ and also manually created the destination file(which is right now blank). But executing the package in the manner as stated above, destination file is not populated with data. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-26 : 06:39:03
|
| What happens?Does it give an error?Does the dts package have a hard coded server name? If so it will try to get the data from the original server not the one it is running on.Are you logging execution?Things are a lot simpler if you keep dts packages as files rather than in a sql server.Note that if you hold the package in a server then that does not affect it's execution - it will be extracted to a file bnefore running - the server is just a store for the package.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
MSDE and DTS