Re: Want to Call DTS Package....

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 02/25/05 

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

Relevant Pages

  • Re: Browse the .CSV file import data from that CSV file into maste
    ... And patrick i have facing one more problem, See below in that command button ... Private Sub CommandButton12_Click ... .CSV once i select the particular csv file click open, ...
    (microsoft.public.excel.programming)
  • Re: [SLE] firefox suddenly doesnt work
    ... On Mon July 25 2005 2:19 pm, Carl E. Hartung wrote: ... > Hi Patrick, ... > If I hadn't done anything to alter my installed programs or libraries and I ... > running rpm on the command line, don't forget to run SuSEconfig and ...
    (SuSE)
  • Re: Want to Call DTS Package....
    ... create an Operating System Command job step. ... "Patrick" wrote in message ... >>> I want to call DTS Package from Job. ... >> Right-click on the DTS package you want to schedule. ...
    (microsoft.public.sqlserver.dts)
  • Re: Want to Call DTS Package....
    ... create an Operating System Command job step. ... "Patrick" wrote in message ... >>> I want to call DTS Package from Job. ... >> Right-click on the DTS package you want to schedule. ...
    (microsoft.public.sqlserver.server)
  • Re: Want to Call DTS Package....
    ... create an Operating System Command job step. ... "Patrick" wrote in message ... >>> I want to call DTS Package from Job. ... >> Right-click on the DTS package you want to schedule. ...
    (microsoft.public.sqlserver.programming)