hi all, i am trying to import the data from a foxpro9.0 database, but the prbolem is we dont have an OLEDB provider for Foxpro 9.0 in DTS. so I have downloaded online and installed the driver on my machine.But i am still unable to see the driver when i hit connection and datasource tab in DTS desinger sheet. i have checked the driver installation process many a times to make sure that i am not missing anything. did you guys face this situation before. please help. do we have to do a seperate process after installing the driver or will the sql will take it right away. i have restarted the server but still i didn't help. when i searched online i found at that the driver should appear in Crogram FilesCommon FilesSystemOle DB the driver shows up in there but from DTS designer sheet i am still unable to see the driver. plesae help if you guys have experience this before. thanks in advance.
See whether you can apply this OLEDB drive http://www.microsoft.com/downloads/...8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en from here and workout your task.