December 5, 2005 at 3:35 pm
Thank you very much everyone for your reply. They are really very helpful.
Our SQL Server is 64-bit SQL Server 2000. What I am getting from this thread is that DTS packages cannot be migrated to a 64-bit server but we can migrate our DTS packages to a 34-bit server and run it connecting to the 64-bit server. Is this correct?
December 6, 2005 at 6:08 am
This is the 64-bit edition of SQL Server, which runs on 64-bit hardware. Both SQL2000 and SQL2005 have 64-bit editions
DTS does not work on 64-bit SQL2000 because Microsoft never ported to that environment.
DTS does not work on 64-bit SQL2005 because DTS is replaced by Integration Services (SSIS) in SQL2005. SSIS works fine on 64-bit SQL2005.
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
December 6, 2005 at 10:57 am
There's an article on porting DTS to SSIS today but it doesn't say anything about the environment.
Should we assume that you cannot port DTS to SSIS on the 64-bit platform?
December 7, 2005 at 3:15 am
My understanding is that once you have migrated your DTS to SSIS, it can run on SQL2005 in either 32-bit or 64-bit mode.
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
December 7, 2005 at 10:16 am
But it looks like you have to have a 32-bit server to do the migration first, then you can move the SSIS package over to the 64-bit server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply