move foxpro .dbf file to sql server 2005 with SSIS

[mjf123456]

I need to convert a DTS package to a SSIS package. The DTS package moves data from a Foxpro database .dbf file to a SQL Server 7 database. The new SSIS package will move the same Foxpro .dbf file to a SQL Server 2005 database.

Attempts to run the DTS package under SSIS hasn't worked. Neither have attempts to convert the DTS package to SSIS with the conversion wizard.

I would prefer using the newer technology. If anyone has any advice, examples and/or procedures, please respond. Thanks

 

[MDXer]

Rebuild it manually. This may seem like a pain but you know it will run how you need it to.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[mjf123456]

Thanks Paul. Since I sent in the original post, I have been trying to build an SSIS package. I am having problems creating a connection for the .dbf file. First I tried to create a Flat File connection manager, but the Flat File Connection Manager Editor wants information about row and header delimiters that I don't have, and can't find on the web.

Following a tip, I created an OLE DB Source connection by right clicking "New" in the Connection Manager, then choosing "Native OLE DB/Microsoft Jet 4.0 OLE DB Provider". I placed the path to the .dbf file in the "Database File Name" box. Then clicked the "All" button, underneath the "Connection" button, on the left side of the pane. I scrolled to "Extended Properties" and entered "dbase 5.0"

The Test Connection said the connection was valid.

Then I entered the file name: audit.dbf. The connection test fails. The error message says it failed because of an error in the initializing provider, and says the path is invalid.

A tip on the web said that the file name must be 8.3, so I made a copy of the dbf file and named it audittst.dbf. The connection test failed as before.

When I remove the dbf filename from the path, the test succeeds. I know the dbf file exists and contains data. The file is on a different server. Since intel-a-sense shows the path and dbf file name, I know there is a connection.

Any ideas?