• The specified DSN contains an architecture mismatch between the Driver and Application.

    BIDS/VisualStudio is a 32-bit app. You'll also want to install the 32-bit OPENEDGE driver and create a DSN using the 32-bit Data Sources dialog. When you deploy to a 64-bit server if SSIS is run under a 64-bit context it will look for a 64-bit DSN and use the 64-bit driver and your SSIS package should not mind nor need to change when running under either bitness.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato