DTS 2000 not running in SQL Server 2005

I'm having a problem running a legacy DTS in SQL 2005. I've installed the
Feb 2007 feature pack and my DTS jobs still are not working. I open package
and click start, the package runs for a few moments and then abruptly closes
Management Studio. I've tried running this from SQL Agent and it still
failes.
The package was created with the BI accelerator.
Thanks,
--
RonHi Ron
Have you run SQL profiler against it to see what is happening? If this uses
a third party component has his been installed correcly?
John
"Ron" wrote:
> I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> Feb 2007 feature pack and my DTS jobs still are not working. I open package
> and click start, the package runs for a few moments and then abruptly closes
> Management Studio. I've tried running this from SQL Agent and it still
> failes.
> The package was created with the BI accelerator.
> Thanks,
> --
> Ron|||John,
Thanks for the reply. Actually the BI Accelerator is/was a Microsoft
Application (Microsoft Accelerator for BI), but I believe it's been retired.
I think the issue was with the compatibility level of my DB's. I had them
set to 80 instead of 90. I'm going to do a bit more testing, but I hope that
was the problem.
If you can think of anything else I should check please let me know.
Thanks,
--
Ron
"John Bell" wrote:
> Hi Ron
> Have you run SQL profiler against it to see what is happening? If this uses
> a third party component has his been installed correcly?
> John
> "Ron" wrote:
> > I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> > Feb 2007 feature pack and my DTS jobs still are not working. I open package
> > and click start, the package runs for a few moments and then abruptly closes
> > Management Studio. I've tried running this from SQL Agent and it still
> > failes.
> >
> > The package was created with the BI accelerator.
> >
> > Thanks,
> > --
> > Ron