<div>
I don't believe there is a driver for 64bit. You need to execute the package using dtexec to call the package using 32bit. In sql server agent set the type to 'Operating system (CmdExec)' and then set it something like this...<br />
<br />
Here is an example<br />
<br />
&quot;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.<wbr />exe&quot; /FILE &quot;C:\TEST\Packages\TEST.dts<wbr />x&quot; /MAXCONCURRENT &quot;&nbsp;-1 &quot;&nbsp;/CHECKPOINTING OFF
</div>


I don't believe there is a driver for 64bit. You need to execute the package using dtexec to call the package using 32bit. In sql server agent set the type to 'Operating system (CmdExec)' and then set it something like this...

Here is an example

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "C:\TEST\Packages\TEST.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

<div>
I used an alternative solution, but thanks for your help
</div>


I used an alternative solution, but thanks for your help

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Regards, <br />
<br />
-K<br />
<br />

</div>
</div>


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. 

Regards, 

-K



Using the &quot;Microsoft Text Driver&quot; on a Windows 2008 (64 bit)

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Using the &quot;Microsoft Text Driver&quot; on a Windows 2008 (64 bit)

Using the "Microsoft Text Driver" on a Windows 2008 (64 bit)