Hi!
Want to process AS2000 DataBase that is located on one server
from 2005 ServerAgent that is located on other server.
SQL2005 Integration Services allows processing only of 2005 OLAP Databases.
I could send an xmla-script to as2000 from a task o ServerAgent2005 but
I've read that AS2000 doesn't support xmla scripts with process command.
How could I do this without migrating 2000 databases to 2005?
Thank you in advanced. Mastroyani .
You could create a DTS package that contains the AS2000 processing tasks you need. The package could the be run with dtsrun.exe from your agent job.|||The problem is, that on AS2000 machine there's only AnalysisServices installed
(No SQL Server and also no DTS).
Are there some other possibilities?
|||You have an option of writing a small DSO program which processes whatever you need, and then you can launch this program from DTS on any machine you want to.|||Спасибо! :) Так и сделал.
No comments:
Post a Comment