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.
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 will load data into by using Data Services. We will use the data stored in the Person
table from the OLTP database as the source data to be loaded.