Creating a target data object

A target data object is the object to which we send the data within a dataflow. There are a few different types of target data objects, but the two main ones are tables and flat files. In this recipe, we will take a look at a target table object.

Note

Views imported into a datastore cannot be target objects within a dataflow. They can only be a source of data.

Getting ready

To prepare for this recipe, we need to create a table in our STAGE database. To do that, please connect to SQL Server Management Studio and create the Person table in the STAGE database using the following command:

CREATE TABLE dbo.Person
(
  FirstName varchar(50),
  LastName varchar(50),
  Age integer
);

This table will be used as a target table, which we ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.