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 |
|
jeroena
Yak Posting Veteran
76 Posts |
 Posted - 2002-10-10 : 05:34:28
|
| Hello,How can I write a script to deploy a DTS package into a certain database server? I use SQL Server 2000 and an external tool to export a DTS package to a .dts file. I want to deploy the DTS packages along with the installation of a certain database. I use osql to execute .sql files to do this.Thnx in advance, Jeroen. |
|
|
lozitskiy
Starting Member
28 Posts |
Posted - 2002-10-10 : 09:55:33
|
| You can save dts package to file *.dts, send it to another server and run it by using dtsrun.exe (it needs to set user and password for package).-------------MCP MSSQL |
 |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2002-10-11 : 02:37:13
|
| Hi,As far as I can tell, I can use dtsrun to run package from a file, or a package stored in the msdb database. Maybe my question was a bit fuzzy :), but I'd like to import the .dts file into the msdb database.Anyone?Thnx., Jeroen. |
|
|
|
|
|
|
Deploying a DTS package