I am trying to import .dbf files using for each container in SSIS. But i keep getting errors to map the files and other errors.
Here is what did.
Use for each container.
Use a data flow task in the container.
Use
OLE DBsource for Visual FoxPro (orjet) and set extended properties as DBase IV and connection string as variable from expressions.Use another variable for sql server table name, removing
.dbfextension.Use a
SQLOLEDBdestination and set its table as table, view or variable name. Set the variable to created one in step 4.
As the SQL Server table is not there already, how can I create and import dynamically. There are a lot of .dbf files so I am looking for dynamic creation of the same and import.
Aucun commentaire:
Enregistrer un commentaire