Hi,

Firstly, sorry if this thread is in the wrong place!

I am attempting to extract from a Unidata database (7.1) which is on a AIX OS, to a MS SQL Server 2008.

I have tried using the wizard with the following connection string, against the option: .Net Framework Data Provider for Odbc.

DSN=test;SRV=host;DBQ=/u/ud/TEST.SR;UID=odbc;PWD=*****;

And while it does connect and allows me to see all my tables, when I try to import any of th data I get a message that says:

"Cannot find column -1" and then the import fails!

I can import fine via Excel or MS Access, just not into SQL Server 2008.

Any help would be greatly apreceiated.