Loading data into a flat file

This recipe will teach you how to export information from a table into a flat file using Data Services.

Flat files are a popular choice when you need to store data externally for backup purposes or in order to transfer and feed it into another system or even send to another company.

The simplest file format usually describes a list of columns in specific order and a delimiter used to separate field values. In most cases, it's all you need. As you will see a bit later, Data Services has many extra configuration options available in the File Format object, allowing you to load the contents of the flat files into a database or export the data from a database table to a delimited text file.

How to do it…

  1. Create a new dataflow ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.