dbTalk Databases Forums  

DTS Shut down Windows

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Shut down Windows in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
magdziarz@gmail.com
 
Posts: n/a

Default DTS Shut down Windows - 08-17-2006 , 11:09 AM






I'm looking for a way to have a DTS job to shut down windows once it is
complete. Is it possible, perhaps through an ActiveX script?

Thanks!


Reply With Quote
  #2  
Old   
Nils Magnus
 
Posts: n/a

Default Re: DTS Shut down Windows - 08-17-2006 , 11:21 AM






Sure, try an ActiveX script:
http://www.motobit.com/tips/detpg_wm...stem-shutdown/

Regards,
Nils Magnus

<magdziarz (AT) gmail (DOT) com> wrote

Quote:
I'm looking for a way to have a DTS job to shut down windows once it is
complete. Is it possible, perhaps through an ActiveX script?

Thanks!




Reply With Quote
  #3  
Old   
magdziarz@gmail.com
 
Posts: n/a

Default Re: DTS Shut down Windows - 08-17-2006 , 11:40 AM



It just completes when I run that without shutting down. Any
suggestions?


Reply With Quote
  #4  
Old   
john pryor
 
Posts: n/a

Default Re: DTS Shut down Windows - 08-17-2006 , 10:22 PM



I run a dts package every night that reboots my web server and firewall. Just
create a package that uses the "shutdown.exe -r" command and that should do
the trick. "-r" is for reboot and you can even have your dts package shutdown
remote machines by using the "-m" parameter. There are several more
parameters for the shutdown.exe command but you can look them up by typing
"shutdown.exe /?". I hope this helps.
--
John Pryor


"magdziarz (AT) gmail (DOT) com" wrote:

Quote:
It just completes when I run that without shutting down. Any
suggestions?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.