DTS Error 1st Time -- sql server programming

Aaron [SQL Server MVP]
6/4/2004 12:23:17 PM

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.)

[quoted text, click to view]

Prabhat
6/4/2004 9:48:54 PM

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 server programming : DTS Error 1st Time