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 |
|
mariam88
Starting Member
1 Post |
Posted - 2012-07-03 : 00:38:55
|
| hi everyone. this is my first post i hope it will be worthfull.i am using sql server 2000. and the system i used is already have DTS packages made by one of my senior.i want to make the exe of dts packages and dumb the exe file in all the computers of my office so that the employee run only the exe file.not to open the sql server and execute package.please tell me how is this possible. and i appreciate and thankful for more detail answer. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2012-07-03 : 10:40:18
|
| you can create DTS package and run it using DTEXEC:e.g.:DTEXEC.EXE /F "C:\My Files\SampleDTSFile.dts"from your Command Linelist of all parameters is available:http://msdn.microsoft.com/en-us/library/ms162810%28v=sql.90%29.aspx |
 |
|
|
|
|
|