January 15, 2010 at 3:26 am
Is it possible to import dtsx package from SQL 2005 to SQL 2000?If yes, how?
January 18, 2010 at 3:23 am
Any suggestion will be appreciated.
January 18, 2010 at 4:37 am
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
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
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
See identical topic http://www.sqlservercentral.com/Forums/Topic849017-146-1.aspx
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy