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