We are using SQL Server Integration Services on several servers for our customers. We sync data from a Pervasive database and calling the SSIS packages from a .NET application. All servers are working fine using the .Net Providers\Odbc Data Provider but now we have one server where we can't get it to work.
We get this error
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
When I do a manual import from Pervasive using the .Net Providers\Odbc Data Provider it works fine
The different on this server from the other ones is:
Windows 2008 Enterprise SP2 (all other server are Windows 2008 R2 Standard)
MS SQL 2008 (all other servers are MS SQL 2008 R2)
All servers are 64 bit.
Any idea what to look for?