473,397 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 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 8803
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

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

Similar topics

0
by: stant | last post by:
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have...
0
by: AMAN | last post by:
Hi all, I am a newbie to SSIS.Need a solution to couple of issues I am currently facing while developing ETL in SSIS 1) Under SSIS Package Folder I have defined mappings for 17 dimensions....
0
by: squashead | last post by:
Hello, I'm in the process of moving data from one database to another. Both are Microsoft sql 2005 databases. I planning on using SSIS to do this but have run into a problem. Since the source...
0
by: Neff | last post by:
I have a clustered installation of SQL Server 2005 with SSIS installed on the cluster. I'm running SQL Server Management Server on one of the cluster nodes and trying to connect to the...
0
by: hoots | last post by:
The Problem: I want to be able to use an assembly of an independant application which is not strong named from within an SSIS script component. I have created a wrapper assembly (Utils.dll)...
3
by: stephen | last post by:
I had to use use ssis 2005 in a short project recently & had little time to work it out. I was importing a whole bunch of flat files into SQL Server tables with many derived columns and...
1
by: k4 | last post by:
I was able to create a new table using dts package and an incoming flat file that had col names in the first row. Can this be done with SSIS?
2
by: karen.google | last post by:
I have an SSIS package that I'm converting from DTS (SQLServer 2005), and the ActiveX Script Task (in VBScript) is deprecated, so I'm trying to convert things to Script tasks (in VB .net). I...
3
by: Tim | last post by:
Hi Folks, I'm used to a UNLOAD command that allows me to dump to a named flat file the results of any SELECT statement. Hence one can build a single SQL file which contains multiple SQL...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.