468,554 Members | 1,891 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

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 8457
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
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.