How to create output dbf file in ssis?

Question

Microsoft SQL Server Integration Services

Good afternoon,
Please tell me, it is necessary to create a dbf file on the output of ssis. Information is taken from mssql. I don't quite understand how to do it.
In the source, I choose ole db and connect with mssql, which destination to choose to get dbf.

Answer 1

The answer to all who will seek this information. Step-by-step instructions for outputting information from MSSQL to DBF:
1) In the control flow, pull out the data flow task block and go into it
2) You need to add an OLE DB source and choose to connect it to MS SQL
3) Add an OLE DB destination:
a) Create a connection manager.
b) Select the Microsoft Jet 4.0 OLE DB Provider at the top 4) Connect the source and destination. In the destination, select our dbf file and match. Click OK 5) Delete the connection arrow and add the "Data Transformation" block From source arrow blue to data transformation from data transformation blue arrow to destination
c) Write the name of the database file, if the file is located along the path "C:\test.dbf", then write in the name of the database file "C:\."
d) We do not change the username and password
e) Go to the "All" tab on the left. In the Extended Properties line, write dbase 5. Click on the bottom to check the connection (It should connect)
6) We go into the data transformation, select all the fields and translate the text fields into Unicode
7) Go to the destination in the mappings and on the text fields we select copies from the data conversion
8) Run. Profit *___*

Answer 2

How to create dbf using SSIS ?

Answer 3

First, install the DBF ODBC driver and then the standard import and export utility.
They say that there are drivers in this package https://www.microsoft.com/en-us/download/details.a...