DTS ActiveX Script Task..vanished

I have no idea what's going on.. but when I open the SQL DTS designer.. there's no ActiveX Script task on the left toolbar anymore. It used to be there. How do I get it back?? I remember playing around with some dts dll files on my machine... maybe I did something that made it go away (note: the DB server is not on my machine.. I just run Enterprise Manager on my machine to access it). Should I reinstall Enterprise Manager?OK, weird. I registered a new task, I pointed to axscphst.dll, having a feeling that was the ActiveX stuff I needed. It was.. ActiveX Script Task is back, along with many other tasks.. but they all have a strange page icon now. Not a huge issue really, but how do I get these tasks to their original appearance ?

DTS / Export Data in Sql2005 Mgm Studio

Dear all,

I have a SQL 2000 and SQL 2005 servers separately, but by whatever reason, I can't use SQL 2000 Enterprise Mgr anymore now so I have to use SQL 2005 Mgm studio to open up my SQL 2000 databases now.

However, I'd like to export data from Sql 2000 to another Sql 2000 server, but via a Sql 2005 mgm studio interface right now. How can I do so? I can't find "Export Data" from the "Task" context menu in Sql 2005 mgm studio.

Thanks,

Hi,

if you want to use the SQL Server MS for that you have to right click on whatever database on choose Tasks..Export data. That should be straight forward for you like in SQL 2k days.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de