Post reply

how to covert this dts package to ssis package

  • April 10, 2008 at 10:01 am

    #120861

    hi,

    Iam trying to migrate the dts package to ssis. I attached the dts here.

    It would be great help for me if you give me step by step approach to finish this task.

    is there any tools we can use for this migration?

    or can we use migration wizard for this?

    plz help me out

    thanks

  • April 10, 2008 at 11:41 am

    #801120

    is there any automation tool for converting dts package to ssis package?

  • April 10, 2008 at 12:01 pm

    #801132

    Hi Gary,

    I have not done any DTS upgrade but I did find this site pretty useful.

    http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

  • April 10, 2008 at 1:28 pm

    #801161

    could you plz tell me how to do this from sracth in ssis

  • April 14, 2008 at 7:34 am

    #802057

    I believe you are beginner in SSIS.

    To make your life easy , all you need to do is, find out the equivalent Tools in SSIS for the Tools you have used in DTS Package.

    I have seen the dts.doc and i believe the following tools would be helpful for you.

    1. Try to create a Project using Bussiness Intelligence Development Studio(BIDS)/

    2. Learn about Connection Managers in SSIS.

    3. Learn about DataFlow Task

    4. Learn about Precendence Constraints.

    5.Working with Global Variables

    6. Execute DTS 2000 Package Task

    If you can implement small examples using this tools, your problem will be solved and you will get confidence also.

    Reference Links

    1. MSDN Books Online

    2. http://www.sqlis.com

    3. http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

    4.http://dotnetslackers.com/articles/sql/UsingSQLServerIntegrationServicesSSIS.aspx

    Regards

  • April 14, 2008 at 2:57 pm

    #802275

    Hey Gray , rt now i am doing DTS migration. I have 70 dts packages. ( but i am not a pro....) this is my first migartion too... But i found migration wizard very helpful. I was lucky my packages are not that complex. most of them uses SQL tasks and basic others tasks that could be very easily convertable.

    there are few things that will not get converted. If u have global variables in the package, the task will be more difficult.

    Also, Active X-script tasks are suppotred, but to a certain extent.

    My suggestion. use Migartion wizard and go step by step in the package to make work .

    Thanks

  • April 14, 2008 at 3:13 pm

    #802283

    Hey Gray CHEERSSSSSSSSSSSSSSSS !!!

    Ur package is much simpler than what i have expected. There will 95 % migration in this package.

    I see it has dynamic properties task, not supported in SSIS, so delete that task and use config file or others accordingly....

    there are 2 OLEDB conns, so and 2 SQL task both will migrate with ease. However ur conns will be in the connection manager not in workflow.

    rest all are either flat file destinations or source, so they will be mapped accordingly in the Connections manager.

    Best of Luck with connections manager and try to keep track of it. ,.........u will get overwelmed by connections that u will se once u migrate.

    :AGAINA: USE DTS MIGRATION WIZARD-------

  • April 14, 2008 at 3:52 pm

    #802292

    Good advice from gyanendra.khadka & mahesh.vsp. The Migration Wizard works pretty well for simple packages. The advice to learn about SSIS before migrating from DTS is a good idea also. If you don't get some experience with SSIS, you'll end up with packages that you don't know how to maintain.

    If you want to take the easy way, check out www.dtsxchange.com.

    Greg

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply