May 13, 2010 at 2:20 pm
Hi Guys,
I want to import data from a .DBF file to SQL Server 2005. I have read a lot of forums and most of them say the same thing.
Using SSIS create a Connection Manager > Select Provider Native OLE DB\Microsoft Jet 4.0 OLE DB provider > All - Advanced - Extended Properties- dbase IV > Create a OLEDB Source and Destination > ---------------This is where the problem starts, after i select the OLE DB connection manager and goto Name of the table of the view, i get an error message that says this is not a valid path. I read somewhere that since i am using a 64 bit machine this error is because of that so i went to project > properties and changed the debugging> Run64BitRuntime to False.
But i am still not able to do it.
Can anyone help with this.
May 13, 2010 at 7:04 pm
Are you running this through BIDS or from a SQL Agent Job?
That setting only applies to BIDS. Also, what directory is devenv.exe running out of?
CEWII
May 14, 2010 at 9:34 am
I am using BIDS, on a different post i was asked to download the latest foxpro driver. I did that too but it still is showing me the same error!
May 14, 2010 at 9:37 am
The exe file devenv is in the c directory.
May 14, 2010 at 1:59 pm
Is that:
C:\Program Files
or
C:\Program Files (x86)
?
CEWII
May 14, 2010 at 2:04 pm
Its in C:\Program Files\Microsoft Visual Studio 8.0
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply