• There are some flaws in this article:

    * Run64BitRuntime is a design-time debugging property, which has nothing to do with packages running on a server.

    * Why would you want to install the x86 ACE OLE DB provider on your server? As Phil said, there's no difference between an Excel file created by 32-bit Excel or 64-bit Excel.

    The only thing this article describes is how you can create the package, because BIDS is a 32-bit application.

    For example if you schedule the job in Agent - Agent is running as a 32-bit process and cannot run any 64-bit dtsx package.

    Agent is not a 32-bit process if SQL Server is 64-bit. If you do have a 64-bit SQL Server, SSIS packages scheduled with Agent run in 64-bit, unless you explicitly specify that 32-bit has to be used.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP