Could you tell me how to migrate the DTS which has the Active Script included
or do you have any other suggestion for me?

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

[quoted text, click to view]