SQL Server Performance

Migration from DTS 2000...

Discussion in 'SQL Server 2005 General Developer Questions' started by ramkumar.mu, Apr 24, 2006.

  1. ramkumar.mu New Member

    We are migrating DTS 2000 packages to SQL Server 2005 SSIS. We are facing following migrations issues :



    1) For Activex Script using DTS Global variables – As per Microsoft documentation this is not supported in SSIS 2005, any alternatives?
    2) Using Dynamic Properties of DTS 2000 – again, any alternatives



    Pl. let me know if you have any solution for the same.


    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
    ramkumar.mu, Apr 24, 2006
    #2

  2. satya Moderator

    Check this MSDN2 help page:http://msdn2.microsoft.com/en-US/library/ms143462(SQL.90).aspx about known migration issues.
    Useful articles about migration :
    http://msdn2.microsoft.com/en-US/library/ms143552(SQL.90).aspx
    http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp
    http://www.simple-talk.com/2005/11/18/dts-to-ssis-migration/

    Fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Apr 24, 2006
    #2

  3. ramkumar.mu New Member

    Thanks for the links satya

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
    ramkumar.mu, Apr 24, 2006
    #2

Share This Page