 | |
Re: DTS Error 1st Time
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: DTS Error 1st Time -
06-07-2004
, 01:18 AM
|
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 (AT) hotmail (DOT) com> wrote in message news:#pWPr#kSEHA.1368 (AT) TK2MSFTNGP11 (DOT) 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 |
#2
| |||
| |||
|
|
Thanks Aaron for your adv. I was not aware of that Group. I will post this on the DTS Group. Thanks Prabhat "Aaron [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote in message news:uqvngBlSEHA.2128 (AT) TK2MSFTNGP09 (DOT) phx.gbl... 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 (AT) hotmail (DOT) com> wrote in message news:#pWPr#kSEHA.1368 (AT) TK2MSFTNGP11 (DOT) 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 |
#3
| |||
| |||
|
|
Not sure I understand. You execute this string the first time and nothing happens. You execute it again and it works fine? |
Guessing is there any Environment settings involved there in 1st time so it
is not able to execute but 2nd time onward as the environment is already set
so works fine. (This is what I am guessing, don't know if i am correct?)
Quote:
|
You mention an error here as well. What error? Where? Error description? |
ERROR Code Returned by DTSRUN is 1.
Thanks
Prabhat
Quote:
|
-- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote in message news:uMyYFdFTEHA.3724 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Thanks Aaron for your adv. I was not aware of that Group. I will post this on the DTS Group. Thanks Prabhat "Aaron [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote in message news:uqvngBlSEHA.2128 (AT) TK2MSFTNGP09 (DOT) phx.gbl... 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 (AT) hotmail (DOT) com> wrote in message news:#pWPr#kSEHA.1368 (AT) TK2MSFTNGP11 (DOT) 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 |
#4
| |||
| |||
|
|
See Reply In-Line. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uFZayAGTEHA.2324 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Not sure I understand. You execute this string the first time and nothing happens. You execute it again and it works fine? YES. 1st Time nothing happens and second time onward works fine. So I am Guessing is there any Environment settings involved there in 1st time so it is not able to execute but 2nd time onward as the environment is already set so works fine. (This is what I am guessing, don't know if i am correct?) You mention an error here as well. What error? Where? Error description? ERROR Code Returned by DTSRUN is 1. Thanks Prabhat -- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote in message news:uMyYFdFTEHA.3724 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Thanks Aaron for your adv. I was not aware of that Group. I will post this on the DTS Group. Thanks Prabhat "Aaron [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote in message news:uqvngBlSEHA.2128 (AT) TK2MSFTNGP09 (DOT) phx.gbl... 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 (AT) hotmail (DOT) com> wrote in message news:#pWPr#kSEHA.1368 (AT) TK2MSFTNGP11 (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.