Hi All Gurus
I am trying to import data from FoxPro Files.
i get the files in.dbf format.

now when i created a link server with that file, and tryed to import i keep
on getting the below error.
Server: Msg 8114, Level 16, State 10, Line 1
Error converting data type DBTYPE_DBDATE to datetime.

Now I know that there is a datatime column called Start_Dt in FoxPro dband
it has corrupted data, but the column that inserts into sql server is
varchar(50). so irrespective of what the data in the foxpro is it should
import.

but somehow there is some check done everytime i try to import the data for
datetime data.

Now when i do a DTS package, it does not give me any errors. It populates
all the data irrespective and it seems that it does not do that check.

Now my problem is i cannot create DTS packages. I have to use LnkServer.

Please help
I need to resolve this ASAP.

i tried to play around with all the Link server OLE DB Provider settings,
inprocess, dynamic parameter,non transact.