Post reply

Importing dtsx package from SQL 2005 to SQL 2000

  • January 15, 2010 at 3:26 am

    #144347

    Is it possible to import dtsx package from SQL 2005 to SQL 2000?If yes, how?

  • January 18, 2010 at 3:23 am

    #1104840

    Any suggestion will be appreciated.

  • January 18, 2010 at 4:37 am

    #1104865

    try exporting the package from SQL 2005 using Management studio, and import the package into SQL 2008 using Management studio(2K8)

    Regards | Enbee

  • January 18, 2010 at 6:56 am

    #1104908

    You want to move the DTS back to 2000 ? If you open the package in 2005, and choose "save as" and select the 2000 server, maybe that will work ? I did a quick test on my servers and "save as" to a 2000 server seemed to work.

    I know there are migration tools to go from 2000 to 2005 (3rd party & native). Perhaps they would work the other direction too for single or multiple packages. I haven't tried going backwards, so there may be compatibility issues that prevent this.

  • January 19, 2010 at 2:43 am

    #1105292

    You cannot transfer a SSIS package from SQL 2005 or above to SQL 2000 DTS. SSIS and DTS are two separate products.

    You can install SSIS on a SQL Server 2000 box and run SSIS against SQL Server 2000.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • January 19, 2010 at 7:04 am

    #1105392

    See identical topic http://www.sqlservercentral.com/Forums/Topic849017-146-1.aspx

Viewing 6 posts - 1 through 5 (of 5 total)

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