From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Loading data to a destination

Loading data to a destination - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Loading data to a destination

“

- [Instructor] The last step in any data flow is to output the data that you've ingested and transformed. You can do this by writing into a data file or through a database connection. The data flow that I've put together throughout this chapter, brought in a table and then it transformed it into a couple of different components. At this stage, we have two output tables to deal with. One is an alphabetized list of employees. And the other is a sampled list of customers. I want to output both of these to the Kinetico database. So come up here to the top of the toolbox, and I'll double click on the Destination Assistant. Just like with the Source Assistant, I'm going to choose the SQL Server destination type, then choose New and press OK. And once again, I'm going to come up here to the Provider and switch it over to the SQL Server native client. Then I'll choose the database server instance that holds the Kinetico database. In my case, it's this one here, with the name SQL Server 2019…

Contents