create DBF files using SSIS

[sreekanth123]

Hi,
I want to use data from a sql database and convert it to DBF files using SSIS.

i.e., Want to extract data from a sql table say "abc" and output i want is a DBF table "abc.dbf" .this should be done using SSIS.

[Jos Haemers]

I'm having the same question. Did you find a solution?

Hi,
I want to use data from a sql database and convert it to DBF files using SSIS.

i.e., Want to extract data from a sql table say "abc" and output i want is a DBF table "abc.dbf" .this should be done using SSIS.

[jagged]

Check out: http://technet.microsoft.com/en-us/library/aa337084.aspx

Explains how to make a connection to a DBF. After that it's normal ssis stuff.

If you get the "cannot convert unicode to non-unicode error on your columns" error, use a query to CAST() your strings to nvarchar or nchar...

Good luck