"Ken D." <KenD@discussions.microsoft.com> wrote in message
news:72E9986D-FBC0-4559-B939-ED72369D3737@microsoft.com:

> Allan,
>
> Let me try and clarify what I am trying to accomplish. Currently, the
> user
> has an Access database in which they import a text file from their host
> system for generating reports. I am looking at consolidating the
> backend to
> SQL and using DTS to transfer the data. I still want the user to be
> able to
> click a button (which could fire some VB code to run the DTS or stored
> procedure). I am not sure this is feasible without the user having SQL
> access. I can put the DTS on a schedule however, I am not sure when the
> host
> system export would be performed or how many times during the day it may
> be
> exported. Giving the user the ability to import the data allows
> flexibility.
>
> Is it even possible to accomplish this? I am new to SQL (but learning
> fast)
> and was hoping to get better performance our of the Access database.
>
> Ken
>
> "Allan Mitchell" wrote:
>
>
> > OK then if you must so this then you could look to call sp_start_job
> on
> > the sql server.
> >
> >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref
> /ts_sp_sa-sz_11uq.asp
> >
> > So you want to use the job as a workflow engine?
> >
> > Allan
> >
> > "Ken D." <KenD@discussions.microsoft.com> wrote in message
> > news:8028A14B-E329-4365-9A8E-3210308FEBBD@microsoft.com:
> >
>
> > > Because there would be other step besides the dts transfer.
> > >
> > > "Allan Mitchell" wrote:
> > >
> > >
>
> > > > Yes it is possible. Why are you doing it as a job though when you
>
> > > could
>
> > > > execute the package directly
> > > >
> > > > Redistributing DTS with your program
> > > > (http://www.sqldts.com/default.aspx?225)
> > > >
> > > > Allan
> > > >
> > > > "Ken D." <KenD@discussions.microsoft.com> wrote in message
> > > > news:6079511D-3096-4BCC-B7B2-8708EB1A5CF4@microsoft.com:
> > > >
> > >
>
> > > > > I would like the client to control the dts import. Is it
> possible
>
> > > for
>
> > > > > the
> > > > > end user to run the dts job from a command button?
> > > >
> > >
> > > >
> >
>
> >