• Yes, there are tools available. With our dts packages we see about a 50% conversion failure rate and have to manually do the conversion anyway.

    One such tool that can do conversions

    http://www.pragmaticworks.com/products/Business-Intelligence/dtsxchange/

    ssis tutorial

    http://bi-polar23.blogspot.com/2008/03/new-to-ssis-start-here.html

    Conversion Article

    http://www.sqlmag.com/Article/ArticleID/94095/sql_server_94095.html

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events