Re: Thanx experts..but pls clarify...

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

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 14:50:19 +0530

Hi Madhu,

No need of a pre script if you are running it from Query Analyzer, you can
just execute the procedure with parameters

EXEC dts_sample 'madhu','dbname','password','packagename'

You need the pre scripts only if you retrieve the procedure parameters from
any table.

Thanks
Hari
MCDBA

"madhu" <anonymous@discussions.microsoft.com> wrote in message
news:73e301c4067b$acf15e20$a601280a@phx.gbl...
> hai thax for ur help.
> when i run this procedure in sql analyzer it is asking
> inputs.as per inputs the dts pkg file executing perfectly.
> this means:
>
> "retrieves the userid, domain, password from the windows
> or sql server profile and pass it to the "exec."
> statement"
> Is it right..or can we write any pre script to run this
> procedure??should i create sript so that it will run after
> windows or sql server initiate.if so what is the
> procedure???
> can u clarify urgent

Relevant Pages

  • Re: Run Unix script and permissions...
    ... an expert Windows user. ... as such on unix systems files are usually created without execute permissions. ... script simply clicking on it in the Finder, instead of open the shell, ...
    (comp.sys.mac.system)
  • Re: Closing down Windows with a script
    ... Windows starts to close down but suddenly stops.(it doesn't ... >write even a simple script to do this. ... you should be able to tell your UPS software to execute ... that command in case of power failure. ...
    (microsoft.public.scripting.wsh)
  • Re: Run Logon Script on Workstations Only
    ... > I am creating a script that I want to run at logon in a Windows NT ... but want it to execute on Windows 2000 or XP Professional ... Here is a small example using 'RegRead' (watch for wrapping): ...
    (microsoft.public.scripting.vbscript)
  • RE: Windows Security Templates
    ... Try exec.vbs from the Windows 2000 resource kit. ... >Is there a way to execute a script across the entire domain ... >Policy to apply them. ...
    (Security-Basics)
  • vbscript fails to start windows application
    ... I am trying to execute some applications from within vbscript using ... The thing is that the same script that fails to start aida32 ... So it definitively seems to be related to Windows XP ...
    (microsoft.public.scripting.vbscript)