Re: DTS Error 1st Time

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Prabhat (not_a_mail_at_hotmail.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 13:17:41 +0530

See Reply In-Line.

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uFZayAGTEHA.2324@TK2MSFTNGP10.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@hotmail.com> wrote in message
> news:uMyYFdFTEHA.3724@TK2MSFTNGP10.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@dnartreb.noraa> wrote in message
> > news:uqvngBlSEHA.2128@TK2MSFTNGP09.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@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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Process.Start() problem / slowness
    ... Also, I am guessing a program in debug mode might take a little longer to execute such a request, I might be wrong. ... ProcessStartInfo psi = new ProcessStartInfo; ...
    (microsoft.public.dotnet.framework)
  • Re: OT: afl for NFL Congrats Dave Sikula
    ... Since Hillary is tomorrow's only scheduled guest, ... I'm guessing he walks out to something from Three Dog Night....r ... What good is being an executive if you never get to execute anyone? ...
    (alt.fan.letterman)
  • Re: Dispatching when function name is stated as a symbol
    ... On Aug 31, 2007, at 4:48 AM, Ronald Fischer wrote: x=cb.call ... causes x to contain, I would like to execute ... If you really wanted to separate the name from the rest of the args, it might be more efficient (guessing, not benchmarked!) to say: ...
    (comp.lang.ruby)
  • condition based on subform
    ... Essentially I want some code to execute based on whether there are any ... subform, then execute the code. ... Private Sub Form_Open ... I'm guessing my problem is related to the top level IF statement.. ...
    (microsoft.public.access.formscoding)
  • Re: xp_cmdshell output question
    ... INSERT author_sales EXECUTE ... Russell Fields ... > guessing that I could do a dir> files.txt and then do a BCP import of ...
    (microsoft.public.sqlserver.programming)