Use an ExecuteProcess task.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
[url]www.SQLDTS.com[/url]
I support PASS - the definitive, global community
for SQL Server professionals - [url]http://www.sqlpass.org[/url]

"JP" <jpatel3canada.com> wrote in message
news:000e01c34236$22d90120$a101280aphx.gbl...
> Hi,
>
> I want to run a batch file from the ActiveX Script Task of
> a Local Package. The following is what I have tried
> without success...
>
> Set myShell = WScript.createObject("wscript.shell")
> myShell.run "c:\test.bat 070403"
>
> The error message is Object Required: 'WScript'. I
> downloaded WScript 6.5 from Microsoft's download site, but
> in vain.
>
> Can someone help me run a batch file (shell command, I
> guess) from the VB Script of a package?
>
> Thanks in advance.
> Regards,
> JP
>