Using the "Microsoft Text Driver" on a Windows 2008 (64 bit)
Posted on 2009-04-10
I am using SSIS script task to verify the structure of .csv files that are retrieved from an ftp site. My current implementation was developed on a 32 bit machine. It works fine when using Microsoft Text Driver. When running in our qa environment where the OS is Windows 2008 64 bit, I am receiving the following error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Is there a workaround for this.