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 O’Reilly online learning.

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