DTSRUN

When I am on the sql server and I issue my dtsrun statement, the package
runs fine, however, when I run it from another server, it reports that the
package ran successfully, however, upon further inspection I see that the
package did not run at all.
Any ideas ?
I would check security issues first.
Secondly, what do you mean by it ran successfully? Does your DTS package
throw errors when it runs into problems, or does it just go merrily on about
it's business and report that it finished all of it's steps. (Whether they
were successful or not).
Not much help, but more information would be useful and I'm sure others here
will have more ideas for you.
Rick Sawtell
MCT, MCSD, MCDBA
"rob" <rwc1960@.bellsouth.net> wrote in message
news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net. ..
> When I am on the sql server and I issue my dtsrun statement, the package
> runs fine, however, when I run it from another server, it reports that the
> package ran successfully, however, upon further inspection I see that the
> package did not run at all.
> Any ideas ?
>
>
|||I execute the following from the DOS prompt from a server other than the SQL
server...
C:\dtsrun /SSqlServerIPaddressHere /Uusername /Ppasword /Npackagename
1. Messages appear in the DOS window which state that the package is running
2. The final message states that the package successfully completed
However, upon further review, none of the tasks in the package were
completed.
I did get permission errors to begin with, but after I fixed them, I just
get that the package completed successfully when in fact, none of the tasks
were completed.
"Rick Sawtell" <ricksawtell@.hotmail.com> wrote in message
news:uDER1vclEHA.644@.tk2msftngp13.phx.gbl...
> I would check security issues first.
> Secondly, what do you mean by it ran successfully? Does your DTS package
> throw errors when it runs into problems, or does it just go merrily on
about
> it's business and report that it finished all of it's steps. (Whether
they
> were successful or not).
>
> Not much help, but more information would be useful and I'm sure others
here[vbcol=seagreen]
> will have more ideas for you.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "rob" <rwc1960@.bellsouth.net> wrote in message
> news:TfH%c.75928$N11.50380@.bignews5.bellsouth.net. ..
the[vbcol=seagreen]
the
>
|||Try using the /L option and specifying a log file for the package status
information. This may help you narrow down the problems.
When you run the package from the SQL Server machine, are you logged in as a
local Admin? I'm not sure about the security issues with the DTS packages,
but that is still the first place I would be looking in this case. Check
the log file and see what information is coming back to you.
Rick Sawtell
MCT, MCSD, MCDBA
"rob" <rwc1960@.bellsouth.net> wrote in message
news:GcI%c.76012$N11.16495@.bignews5.bellsouth.net. ..
> I execute the following from the DOS prompt from a server other than the
SQL
> server...
> C:\dtsrun /SSqlServerIPaddressHere /Uusername /Ppasword /Npackagename
> 1. Messages appear in the DOS window which state that the package is
running
> 2. The final message states that the package successfully completed
> However, upon further review, none of the tasks in the package were
> completed.
> I did get permission errors to begin with, but after I fixed them, I just
> get that the package completed successfully when in fact, none of the
tasks[vbcol=seagreen]
> were completed.
>
>
>
> "Rick Sawtell" <ricksawtell@.hotmail.com> wrote in message
> news:uDER1vclEHA.644@.tk2msftngp13.phx.gbl...
package[vbcol=seagreen]
> about
> they
> here
package
> the
> the
>