|
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?
>
Navigation:
[Reply to this message]
|