Im a little confused as to what i can and carnt do. I am
using crystal reports.
If i wanted top get the SQl 2000 server to autogenerate a
CR from a scheduled DTS would thios be possible.

In Vb i just add the libery and i can access the CR dll.
Is this possible under SQL 2000 Server and if so can
anybody explain how to do it

You could I suppose grab the CR object library and use it in an Active
Script task. You would use CREATEOBJECT() to reference the library.
You could also call a compiled EXE to do this through the ExecuteProcess
task.
Does CR not have a scheduling mechanism rather like Business Objects ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote