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 |
|
fizgig
Starting Member
34 Posts |
 Posted - 2002-01-22 : 06:59:41
|
| is this possible? |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-01-22 : 07:12:41
|
| How about:-EXEC master..xp_cmdshell 'dtsrun /S <servername> /U <username> /P <userpassword> /N <dtspackagename> /M <dtspackagepassword>'also search this site for further issues about it. |
 |
|
|
matt_calhoon
Posting Yak Master
235 Posts |
Posted - 2002-01-22 : 08:18:41
|
| another way is to create a scheduled event for the DTS which you can call from a stored procedure like so;CREATE PROCEDURE p_START_DTS_JOB ASEXEC msdb..sp_start_job @job_name ='YOUR_DTS_JOBNAME'I used this method as I was having troubles with permissions over several servers - so I found calling it up like this no problem. |
|
|
|
fizgig
Starting Member
34 Posts |
Posted - 2002-01-22 : 08:31:45
|
Tnx people, it worked  |
|
|
|
|
|
|
Executing a DTS package from SQL