question

srivivek avatar image
srivivek asked

DTS to SSIS conversion time

hi, Is there a way by which we can estimate the time gonna taken for conversion of DTS package to SSIS. If so, can please tell the procedure. Thanks in advance...
ssisdtsconversion
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
Well that all depends. Are you doing this manually or with a tool such as DTS xChange from PragmaticWorks? If doing it manually then it really all depends on the complexity of the DTS Package and your knowledge of SSIS. If using the tool then they may have an estimator but I haven't seen it take more than a few minutes, then you get to spend a little bit of time cleaning a few things up. If you can provide more details and possibly and example we can help more. Many of us have spent a great deal of time migrating DTS to SSIS.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dbaguy avatar image
dbaguy answered
If you download DTS xChange from pragmatic works, it has a free estimator process that will look into each package and let you know how long the project is going to take you (manual or automated) based on a number of knobs that you turn. It then spits out a report to give in PDF or Excel to your PM.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

how accurate would you say its output is compared to the actual time it has taken you to upgrade the packages?
0 Likes 0 ·
thank you guys.i will try downloading it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.