SSIS migration task (msdn)

SQL Server 2008 books online (August 2008) Migration Task

Many SQL Server 2000 data transformation services (DTS) tasks are directly mapped to integration services tasks, migrating a package to integration services can replace a task of SQL Server 2000 with the equivalent task of the task.

The following table lists the direct mappings between the two job versions.

SQL Server 2000 Task	SQL Server 2005 Task
ActiveX script task	ActiveX script task
Large-capacity insert task	Large-capacity insert task
Copy an SQL Server Object task	Transfer An SQL Server Object task
Data Mining and prediction tasks	Data Mining Query Task
Run the Package task	Run the data transmission 2000 Package task
Execute Process tasks	Execute Process tasks
Execute an SQL task	Execute an SQL task
File Transfer Protocol task	FTP task
Message Queue task	Message Queue task
Send email task	Send email task
Transmission database task, transmission error message task, transmission job task, transfer login name task and transmission Master stored procedure task	Transfer An SQL Server Object task,Transfer database task,Transfer error message task,Transfer job task,Transfer login name taskAndTransfer master stored procedure task.

Note:
After the package migration is completed, try to useGlobalvariablesSetParentProperty to access the ActiveX script task of the package object model.

Some SQL Server 2000 tasks are not directly mapped to integration services tasks:

• Analysis Services Task (because the integration services analysis services task cannot run with the SQL Server 2000 instance of Analysis Services)
• Data-Driven Query Task
• Dynamic attribute task
• Data conversion task

In SQL Server, some tasks in these tasks are replaced with non-task functions. The following table lists the mappings between SQL Server 2000 tasks and their equivalent SQL Server non-task functions.

SQL Server 2000 Task	SQL Server 2005 Functions
Dynamic attributes	Configuration and attribute expression. For more information, seeCreate package Configuration.
Convert data	Data Flow taskAndData Flow Elements.
Data-Driven Query	UseGradient Dimension Conversion,Conditional split ConversionAndOle db command Conversion.

Custom task

Packages that contain custom tasks will be migrated to SQL Server in special ways. For each custom task, create an SQL Server 2000 package and add the task of executing the DTs 2000 package that calls the SQL Server 2000 package to the migrated package. The new SQL Server 2000 package, known as the "medium" clause, is embedded in the package for migration and is not stored separately. For example, the SQL Server 2000 package with three custom tasks will be converted into an SQL server package containing three tasks that execute the data transmission 2000 package, each data transmission 2000 Package task points to an embedded SQL Server 2000 package that encapsulates a custom task.

Data extraction task

Three SQL Server 2000 tasks are based on SQL Server 2000 DTS data extraction. These three tasks are data-driven query tasks, data conversion tasks, and paralleldatapump tasks. In addition to simple data conversion tasks, these tasks are all migrated in the same way as custom tasks. The package migration wizard creates a new SQL Server 2000 package for each task, and then adds the running DTS 2000 Package task corresponding to each data extraction task to the new package.

Dynamic attribute task

Dynamic attribute tasks cannot be migrated to SQL Server. If you try to migrate a package with a dynamic attribute task, the package migration Wizard will issue a warning. If you select a migration package, the dynamic attribute task is replaced by a placeholder task in the migrated package. A placeholder task is a script task that lists the "property-value" pairs in a dynamic attribute task that may be transitioned to a script in a script task. This information is written to the script task as a script comment.

In SQL Server, configurations can replace and enhance functions available in dynamic attribute tasks. For more information, seeCreate package Configuration.

See

Other resources

Migrate the data transformation services package