![]() In the Connection Manager, please select “Microsoft OLE DB Provider for Visual FoxPro” Select the DFT, and go to Data Flow designer page.ĭouble-click the OLE DB Source, click “New” > “New” to create a connection to Visual FoxPro. Solution1: Use the Microsoft OLE DB Provider for Visual FoxPro to load data from Visual FoxPro databaseĬreate a new SQL Server Integration Services(SSIS) package.Īdd a Data Flow Task(DFT) to the package. In order to load data from Visual FoxPro to 64-bit SQL Server, we can use Microsoft OLE DB Provider for Visual FoxPro or Visual FoxPro ODBC Driver to load data from Visual FoxPro, and then upload into SQL Server.īelow are the detail steps for your reference:īefore starting the steps, please make sure the Microsoft OLE DB Provider for Visual FoxPro and Visual FoxPro ODBC Driver is installed. ![]() The complete solution was provided by Jin Chen in this MSDN thread How to run SSIS package – Import VFP table to SQL Server 64 bit and I was able to easily follow it and the package ran OK. Turned out I was wrong and it’s easy enough to create SSIS package to run an import of VFP table into SQL Server 64 bit.
0 Comments
Leave a Reply. |