Migrating Scripts

SQL Server Setup

The SQL Server 2000 version of the ActiveX Script task can be migrated to the SQL Server 2005 ActiveX Script task. However the SQL Server 2005 ActiveX Script task is provided only for backward compatibility. After migration, you should replace the VBScript with managed Visual Basic .NET code in the SQL Server 2005 Integration Services (SSIS) Script Task.

ActiveX Script tasks that try to access the package object model by using the Parent property of the GlobalVariables collection will fail after package migration. The former functionality must be replaced by using different script code or new SQL Server 2005 features.

See Also

Other Resources

ActiveX Script Task
Script Task
Migrating Data Transformation Services Packages