I have a Access (2000 File Format) Source in my SSIS, and i have to use
1- the 32 bit DTExec
2- set the Run64BitRunTime = FALSE
before rebuilding the package or in other words deployment (I only copy the Package to a folder on production as a deployment in this case)
My Questions are
1- does Access 2000 have a 64bit file format so that i can use the 64bit DTExec?
2- does access XP or higher version ( Like Office 2010) have a 64bit file format? I know they do but i want to know in SSIS do i have to use the 32bit DTExec for that and why?
3- bottom line, yes i know that i have to use a 32 bit DTExec for Access 2000 but do i
HAVE to set Run64BitRunTime = FALSE to get the package running on a 64bit production enviroment?
Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
View Complete Post