>Hi all,
>
>i have a big problem and i guess there are already a lot of comments on the issue. I have installed a sql server 2008 on a windows server 64bit os. Now i'm making a DTS to transport data from a vfp database to the sqlserver. When i configure the connection in the connection manager and do the connection test everything seems to be ok. When i create my data transfer from the vfp database to te sqldatabase useing this connection i got an error like :
>
>[Connection manager "SourceConnectionOLEDB"] Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider VFPOLEDB.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
>An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
>
>i guess the problem is due to the 32bit to 64bit odbc connections. Is that right and is there a solution for this problem ?
>
>thnx

Looks like you'll have to install a 32bit version of sql http://blogs.lessthandot.com/index.php/All/?p=929