Posted by John Bell on 06/01/05 15:12

Hi

Not really if it works at the command prompt then it should work from
xp_cmdshell. The tip on SQLDTS.com was to let SQL Server create a job for
your package (right click the package and choose the schedule menu) and that
will give you a valid DTSRUN command line.

John

"Cesco" <francesco.viscomi@gmail.com> wrote in message
news:1117612864.920721.261440@o13g2000cwo.googlegroups.com...
> Thank you for the reply. I change the name of server from localhost to
> the name of my machine and i sure that the dts is in correct location
> but the stored procedure doesn't work...
> There is something to set to run stored procedure?
>

[Back to original message]