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.
Views imported into a datastore cannot be target objects within a dataflow. They can only be a source of data.
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 ...