SSIS, Uncategorized

Reliable ways to check whether Microsoft Access Database Engine (64-bit) is installed or not in SSIS.

Run this inside your Script Task:

                bool fireDriverAgain = false;

                Dts.Events.FireInformation(
                    0,
                    "Runtime",
                    Environment.Is64BitProcess ? "64-bit runtime" : "32-bit runtime",
                    "",
                    0,
                    ref fireDriverAgain
                );

Leave a Reply

Prabhakaran Jayaraman