Re: DTSRun and Batch file
From: Jeff Lockard (jlockard_at_rwd.com)
Date: 04/05/04
- Next message: Jeff Lockard: "Re: DTSRun and Batch file"
- Previous message: Paige: "DTS - Append and Update"
- In reply to: Darren Green: "Re: DTSRun and Batch file"
- Next in thread: Jeff Lockard: "Re: DTSRun and Batch file"
- Messages sorted by: [ date ] [ thread ]
Date: 5 Apr 2004 13:34:16 -0700
Darren Green <darren.green@reply-to-newsgroup-sqldts.com> wrote in message news:<vCWAP3NuXvbAFw3T@sqldts.com>...
> In message <279e1d30.0404020827.60e8ba2e@posting.google.com>, Jeff
> Lockard <jlockard@rwd.com> writes
> >Hello -
> >I'm running SQL Server 2000 and I've built 3 OLAP cubes that are
> >refreshed via DTS package, including an Analysis Services task to
> >re-process each cube. Now, I'd like to provide the ability for select
> >users to refresh/re-process the cubes without installing SQL Server
> >EM, Analysis Services on the client machine. Is this possible?
> >
> >I thought that I could do this with DTSRun, so I reviewed the
> >redist.txt and have built a small Zip file with a batch file to
> >register the DTS dll's and copy the rll's to the appropriate directory
> >on the client machine.
> >
> >I performed the zip "install" and register tasks on a client machine
> >without AS or EM. Now, when I run the batch file that calls DTSRun to
> >execute the DTS package, I am getting the following errors:
> >
> >DTSRun: Loading...
> >
> >Error: -2147221005 (800401F3); Provider Error: 0 (0)
> > Error String: Invalid class string
> > Error Source: Microsoft Data Transformation Services (DTS) Package
> > Help File: sqldts80.hlp
> > Help Context: 713
> >
> >I've read some of the other postings, but not sure if they apply
> >directly to my case. Bottom line question: Is it possible to build a
> >tool for non SQL Server/AS client machines to run a DTS package that
> >reprocesses cubes?
> >
> >Thanks in advance.
> >Jeff
>
> No because DTS is a client side tool, and as you know you need to
> install the DTS DLLs on the local machine. So the DTS package is running
> on that local machine from where it is called. The error is probably
> because you haven't installed the OLAP processing task on that machine,
> so the package load fails.
>
> You need to abstract the package execution location from the user, The
> package needs to run on a machine with all the required dependencies,
> best place is probably the server. Perhaps one method is to allow the
> user to start a SQL Agent Job that runs the package. You only need ADO
> for example to call the sp_start_job stored procedure. How you provide
> this as an interface is up to you, but both Win form and web form
> methods could easily be used.
>
> Make sense?
Darren –
What you say about the DTS Package failing on my client makes sense –
I have intentionally not installed EM or AS on that machine.
I think I understand your suggestion about abstracting the package
from the user. I have created a job to run the DTS package on the
server. However, I have not been able to get the job to run when
connected using sa. The job step is "DTSRun" followed by a long
string of alpha characters. Any suggestions on this?
What I was originally thinking was that I could use ISQL to call
sp_start_job, but then I realized that I'd probably need to install
ISQL on the client machine to make that work. Can you educate me a
little on what you meant when you were referring to ADO? I think I it
stands for Active Data Objects, but not sure of what you were
suggesting about implementing a web form or Win form.
Thanks…
- Next message: Jeff Lockard: "Re: DTSRun and Batch file"
- Previous message: Paige: "DTS - Append and Update"
- In reply to: Darren Green: "Re: DTSRun and Batch file"
- Next in thread: Jeff Lockard: "Re: DTSRun and Batch file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
