DTS export problem

Hello

i can 't use DTS export via entreprise manager betwen 2 identic server (same os ,same
sqlserver 7 ,same pack et...)

I have this message

The licensing mode don t let to use DTS export ...

Where i find a parameter ?
Where i find a tool to change the licensing mode ?

RegardsControl Panel/Licensingsql

DTS and Sql Server 2005 Express

OK, I'm still trying to get DTS on SqlExpress. I installed Service Pack 1 and there was nothing extra in the "90" folder. Is there a way to get Excel spreadsheets into the express version? If so, spell it out for me and I'll use it.

Thanks in advance

I finally got it. The magic bits are in the SQLEXPRESS_TOOLKIT package.

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