471,049 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

create DBF files using SSIS

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.
Apr 10 '07 #1
2 8614
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.
Feb 24 '08 #2
jagged
23
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
Feb 24 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Neff | last post: by
reply views Thread by hoots | last post: by
2 posts views Thread by karen.google | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.