dts from command line

if a user runs a dts package from a command line say something like this
C:\>dtsrun /s ServerName /u username /p P1l0t /n DTS_Package
using that /p password switch is the passwork example above P1l0t saved off
somewhere in a log file?
same question for if the command fails.
thanksNo...it won't report or log the password that was used.
-Sue
On Tue, 11 Oct 2005 15:05:05 -0700, "jason"
<jason@.discussions.microsoft.com> wrote:

>if a user runs a dts package from a command line say something like this
>C:\>dtsrun /s ServerName /u username /p P1l0t /n DTS_Package
>using that /p password switch is the passwork example above P1l0t saved off
>somewhere in a log file?
>same question for if the command fails.
>thanks|||thanks sue
"Sue Hoegemeier" wrote:

> No...it won't report or log the password that was used.
> -Sue
> On Tue, 11 Oct 2005 15:05:05 -0700, "jason"
> <jason@.discussions.microsoft.com> wrote:
>
>

DTS Error 1st Time

Hi All,
I am executing a DTS Package from with in a Stored Procedure Like:
SET @.CMD = 'DTSRUN /S ' + @.SERVERNAME + ' /E /N ' + @.DTSNAME + ' ' +
@.GLOBLEVARIABLELIST + ''
EXECUTE @.ERR_NUM = master..xp_cmdshell @.CMD
The 1st Time when I call Stored procedure from My Code. It is Not Executing
the Package. But 2nd time onward that is executing the package and doing all
what ever i want to do.
What is happening in 1st time so that the package is fails? Is that setting
any environment in 1st time and executing the Package from 2nd time onward.
I am too Confused. Need Help.
Thanks
Prabhat
You've posted this at least 6 times already. Have you considered posting to
the DTS group, or having some patience?
http://www.aspfaq.com/
(Reverse address to reply.)
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:#pWPr#kSEHA.1368@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I am executing a DTS Package from with in a Stored Procedure Like:
> SET @.CMD = 'DTSRUN /S ' + @.SERVERNAME + ' /E /N ' + @.DTSNAME + ' ' +
> @.GLOBLEVARIABLELIST + ''
> EXECUTE @.ERR_NUM = master..xp_cmdshell @.CMD
> The 1st Time when I call Stored procedure from My Code. It is Not
Executing
> the Package. But 2nd time onward that is executing the package and doing
all
> what ever i want to do.
> What is happening in 1st time so that the package is fails? Is that
setting
> any environment in 1st time and executing the Package from 2nd time
onward.
> I am too Confused. Need Help.
> Thanks
> Prabhat
>
>

DTS Error 1st Time

Hi All,
I am executing a DTS Package from with in a Stored Procedure Like:
SET @.CMD = 'DTSRUN /S ' + @.SERVERNAME + ' /E /N ' + @.DTSNAME + ' ' +
@.GLOBLEVARIABLELIST + ''
EXECUTE @.ERR_NUM = master..xp_cmdshell @.CMD
The 1st Time when I call Stored procedure from My Code. It is Not Executing
the Package. But 2nd time onward that is executing the package and doing all
what ever i want to do.
What is happening in 1st time so that the package is fails? Is that setting
any environment in 1st time and executing the Package from 2nd time onward.
I am too Confused. Need Help.
Thanks
PrabhatYou've posted this at least 6 times already. Have you considered posting to
the DTS group, or having some patience?
http://www.aspfaq.com/
(Reverse address to reply.)
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:#pWPr#kSEHA.1368@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I am executing a DTS Package from with in a Stored Procedure Like:
> SET @.CMD = 'DTSRUN /S ' + @.SERVERNAME + ' /E /N ' + @.DTSNAME + ' ' +
> @.GLOBLEVARIABLELIST + ''
> EXECUTE @.ERR_NUM = master..xp_cmdshell @.CMD
> The 1st Time when I call Stored procedure from My Code. It is Not
Executing
> the Package. But 2nd time onward that is executing the package and doing
all
> what ever i want to do.
> What is happening in 1st time so that the package is fails? Is that
setting
> any environment in 1st time and executing the Package from 2nd time
onward.
> I am too Confused. Need Help.
> Thanks
> Prabhat
>
>sql

DTS Error 1st Time

Hi All,
I am executing a DTS Package from with in a Stored Procedure Like:
SET @.CMD = 'DTSRUN /S ' + @.SERVERNAME + ' /E /N ' + @.DTSNAME + ' ' +
@.GLOBLEVARIABLELIST + ''
EXECUTE @.ERR_NUM = master..xp_cmdshell @.CMD
The 1st Time when I call Stored procedure from My Code. It is Not Executing
the Package. But 2nd time onward that is executing the package and doing all
what ever i want to do.
What is happening in 1st time so that the package is fails? Is that setting
any environment in 1st time and executing the Package from 2nd time onward.
I am too Confused. Need Help.
Thanks
PrabhatYou've posted this at least 6 times already. Have you considered posting to
the DTS group, or having some patience?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:#pWPr#kSEHA.1368@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I am executing a DTS Package from with in a Stored Procedure Like:
> SET @.CMD = 'DTSRUN /S ' + @.SERVERNAME + ' /E /N ' + @.DTSNAME + ' ' +
> @.GLOBLEVARIABLELIST + ''
> EXECUTE @.ERR_NUM = master..xp_cmdshell @.CMD
> The 1st Time when I call Stored procedure from My Code. It is Not
Executing
> the Package. But 2nd time onward that is executing the package and doing
all
> what ever i want to do.
> What is happening in 1st time so that the package is fails? Is that
setting
> any environment in 1st time and executing the Package from 2nd time
onward.
> I am too Confused. Need Help.
> Thanks
> Prabhat
>
>