| Author |
Running a DTS job from Access...
|
|
| Ken D. 2005-09-21, 8:24 pm |
| 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?
| |
| Allan Mitchell 2005-09-21, 8:24 pm |
| 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@microso
ft.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?
| |
| Ken D. 2005-09-21, 8:24 pm |
| 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@microso
ft.com:
>
>
>
| |
| Allan Mitchell 2005-09-21, 8:24 pm |
| 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/d..._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@microso
ft.com:
[color=darkred]
> Because there would be other step besides the dts transfer.
>
> "Allan Mitchell" wrote:
>
>
> could
>
> for
>
| |
| Ken D. 2005-09-22, 1:23 pm |
| 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/d..._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@microso
ft.com:
>
>
>
| |
| Allan Mitchell 2005-09-22, 8:24 pm |
| DTS has very very little to do with SQL Server except the box in which
it comes. You can use DTS and never see a SQL Server data source ever
some of my clients bought SQL Server for DTS and effectively binned the
relational engine.
Regsitering the dlls on the box that says "Go" will accomplich what you
need.
"Ken D." <KenD@discussions.microsoft.com> wrote in message
news:72E9986D-FBC0-4559-B939- ED72369D3737@microso
ft.com:
[color=darkred]
> 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:
>
>
> on
> http://msdn.microsoft.com/library/d...y/en-us/tsqlref
> /ts_sp_sa-sz_11uq.asp
>
>
>
>
>
> possible
>
>
>
|
|
|
|