Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

migration limits for DTS to SSIS

what tasks, if any, will have issues (cannot be plainly converted) when migrated through wizard from DTS to SSIS package using SSMS interface?
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
2 Solutions
 
HumpdyCommented:
list of known issues covered here. you should read carefully !!!!!!

http://technet.microsoft.com/en-us/library/ms143462.aspx
0
 
anushahannaAuthor Commented:
OK- thanks...

by known issues, does Microsoft imply they plan to fix these in upcoming service packs?
0
 
HumpdyCommented:
I would say definetely not,
these known issues are pretty much a case of . here's what's wrong, and here's a rough guide on how to fix it. I can't see Microsoft upgrading this wizard in any way, considering SQL 2000 is becoming so obsolete.
0
 
Reza RadCommented:
one of the tasks which you will face lots of problems in migrate from legacy DTS to new SSIS is ActiveX task.
there was limited tasks in old DTS and developers should write scripts in ActiveX to implement things, but in SSIS there are lots of powerful tasks which help developers much and they can avoid scripting many times, also there is an Script task which let you to develop anything you need with .NET languages ( C# or VB.NET )
I strongly recommend to re-write your old DTS packages in SSIS, because lots of tasks in SSIS with better performance will help you more to develop your packages better. you should dedicate sometimes to lears ssis at first, but when you get familiar, you will be very satisfied with what SSIS proposed to you as a ETL tool.
0
 
anushahannaAuthor Commented:
great input and advice.. thanks a lot.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now