Re: Want to Call DTS Package....
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 02/25/05
- Next message: chambersdon_at_hotmail.com: "Execute Package Task fails if called from VB"
- Previous message: Patrick: "Re: Want to Call DTS Package...."
- In reply to: Patrick: "Re: Want to Call DTS Package...."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Feb 2005 16:06:46 -0600
exec master..xp_cmdshell 'dtsrun ....'
or
create an Operating System Command job step (via the "Type" listbox).
-- Keith "Patrick" <kingofusa@juno.com> wrote in message news:eX0vxP4GFHA.1500@TK2MSFTNGP09.phx.gbl... > I want to call within SQL Job. dtsrun.exe is command line utility. How can I > run that command line utility with in the Sql Job > thanks > "MGFoster" <me@privacy.com> wrote in message > news:EjMTd.5744$873.83@newsread3.news.pas.earthlink.net... > > Patrick wrote: > >> Hi All > >> > >> I want to call DTS Package from Job. How, can I do that ? > >> > >> First DTS Package transfers data and then it calculates on that imported > >> data. > > > > Right-click on the DTS package you want to schedule. Select Schedule & > > complete the following prompts. > > > > -- > > MGFoster:::mgf00 <at> earthlink <decimal-point> net > > Oakland, CA (USA) > >
- Next message: chambersdon_at_hotmail.com: "Execute Package Task fails if called from VB"
- Previous message: Patrick: "Re: Want to Call DTS Package...."
- In reply to: Patrick: "Re: Want to Call DTS Package...."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
