Hi,<o:p></o:p> <o:p> </o:p> I have several packages that use the wscipt shell to execute the SQL packages. As of recent my packages bomb when trying to execute the wscript shell. I can execute the shell command from the cmd prompt and also tried turning off the virus scanner.<o:p></o:p> Ive provide a simple sample below. Function Main() Dim oShell Set oShell = CreateObject("wscript.shell") oShell.Run "dtexec /F C:\DTSPackages\IntegrationServices\IntegrationServices\Ful_OrderImport.dtsx" Main = DTSTaskExecResult_Success End Function Could I have turned off an option that prevents calling up the wscript shell?

Hi Meyeri, To run dtexec you do not need wscript. Just run it in a .BAT file with say a Start command, or just call dtexec directly. I do not know what error you get, but it is likely that the account executing the script got its rights trimmed.Arthur My Blog

Hi ArthurZ, The file is being run under the administrator account, so I don't think it's a rights issue. The script I posted was only a sample. The real package was much more complex. What I posted was fairly simple and should have run.

What symptoms are you getting? Please post the error as is (omitting security particulars) here.Arthur My Blog

Hi ArthurZ, I was able to correct the issue with a windows update. This particular server was serveral updates behind and after running the updates, it seemed to solve my problem. Thanks for you help. Ian