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