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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to make exe of dts package?

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 Line

list of all parameters is available:
http://msdn.microsoft.com/en-us/library/ms162810%28v=sql.90%29.aspx

Go to Top of Page
   

- Advertisement -