[Webinar] Streamline your web hosting managementRegister Today


Rewriting DTS Packages/ SSIS

Posted on 2010-03-23
Medium Priority
Last Modified: 2013-11-30
Hi All,
I have to work on re-writing few DTS packages developed earlier in sql server 2000 to SSIS SQL Server 2005
Are there any weblinks which could help which show mapping components of DTS to SSIS

like for eg Data Transfer task (DTS) to  Data flow task (SSIS) like that.

I am not looking for migration links from DTS to SSIS info about re-writing them to SSIS
Question by:dotnet0824
  • 2
  • 2
LVL 30

Expert Comment

by:Reza Rad
ID: 28374176
what is your problem with migration?!?
if you want to change dts to ssis , migration is good start point,
if no, you must create all packages again in SSIS
LVL 57

Expert Comment

by:Raja Jegan R
ID: 28411130
Hope you are not aware of Execute DTS Task in SSIS.
Just use this task which is created for executing DTS packages created in SQL Server 2000 in either SSIS 2005 or SSIS 2008.
More info here:


Author Comment

ID: 28432830
I explained to the concerned person that its not necessary to re-write, but they are particular about re-writing. so I am looking for mapping of components.

I am really not sure if there is performance boost in re-writing which might be the reason they are v particular in rewriting.
LVL 57

Accepted Solution

Raja Jegan R earned 1000 total points
ID: 28467875
>> I am really not sure if there is performance boost in re-writing which might be the reason they are v particular in rewriting

Indeed, they are correct to some extent..
Some of the features in SQL Server 2000 have changed or rewritten for better performance in SQL Server 2005 and 2008. Execute DTS Task would execute the package with some reduced performance..

And hence rewritting the code would help in nearly 50 - 80 % performance improvement..

>> I am looking for mapping of components.

Let us know the components for which you need mapping.

Author Closing Comment

ID: 32350146

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question