You can try and use the migration wizard. It only does a best effort job and
unless your ActiveX scripts are very simple, they will probably not work as
intended. You need to re-write them using SSIS Script Task. As a starter, you
can go through the tutorial.
Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk
"Stanley" wrote:
Quote:
Could you tell me how to migrate the DTS which has the Active Script included
or do you have any other suggestion for me?
Many thanks, |