Configuring SSIS OLE DB destination

preview_player
Показать описание
Your package can now extract data from the flat file source and transform that data into a format compatible with the destination. The next task is to load the transformed data into the destination. To load the data, you add an OLE DB destination to the data flow. The OLE DB destination can use a database table, view, or a SQL command to load data into a variety of OLE DB-compliant databases.

In this task, you add and configure an OLE DB destination to use the OLE DB connection manager that you previously created.

Configuring SSIS OLE DB destination-Guide

#SSIS #configuring #OLDDBDestination #Flat-File

Video Chapter:
0:00 Introduction-Configuring SSIS OLE DB destination
01:52 Adding SSIS OLE DB destination
02:12 Configuring SSIS OLE DB destination
Рекомендации по теме