DTRUN command

Hi.
I have a sql job that is failing, while looking why the job failed, In the
preperty Step- tab /command windows: has DTSRun /~ this long address
following .
I just started this gig and I'm not sure what is being called. how can I
found out what procedure or process this job was calling by looking at the
address?
Thanks in advance.Correction: the command is DTSRUN
"ITDUDE27" wrote:
> Hi.
> I have a sql job that is failing, while looking why the job failed, In the
> preperty Step- tab /command windows: has DTSRun /~ this long address
> following .
> I just started this gig and I'm not sure what is being called. how can I
> found out what procedure or process this job was calling by looking at the
> address?
> Thanks in advance.|||The DTS package scheduling wizard encrypts DTSRUN parameters. You can see
the package name retrieved from msdb by using SQL Profiler while DTSRUN is
executed. There are also cracks for the DTSRUN parameters you can find on
the web.
IMHO, it's better to code DTSRUN parameters in clear text unless you have a
reason to do otherwise.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:E8CB6912-5819-4F0F-A81E-5C770AA163FD@.microsoft.com...
> Hi.
> I have a sql job that is failing, while looking why the job failed, In
> the
> preperty Step- tab /command windows: has DTSRun /~ this long address
> following .
> I just started this gig and I'm not sure what is being called. how can I
> found out what procedure or process this job was calling by looking at the
> address?
> Thanks in advance.