Configuring an SSIS OLE DB connection manager
After you add a Flat File connection manager to connect to the data source, you add an OLE DB connection manager to connect to the data destination. An OLE DB connection manager enables a package to extract data from or load data into any OLE DB-compliant data source. Using an OLE DB connection manager, you can specify the server, the authentication method, and the default database for the connection.
In this task, you create an OLE DB connection manager that uses Windows Authentication to connect to the local instance of AdventureWorksDW2012. This OLE DB connection manager is also referenced by other components that you create later in this tutorial, such as the Lookup transformation and the OLE DB destination.
follow me on / goshedy
/ goshedy
/ goshedys
AdventureWorksDW2012 sample database
Download here: https://learn.microsoft.com/en-us/sql...
Steps in Configuring an SSIS OLE DB connection manager
https://learn.microsoft.com/en-us/sql...
OLEDBConnectionManager #SSIS #configuring
Video Chapter :
0:00 Introduction - Configuring an SSIS OLE DB Connection Manager.
01:00 Restoring AdventureWorksDW Database.
05:28 Adding OLE DB connection manager
08:01 Selecting Database in OLE DB connection manager
Смотрите видео Configuring an SSIS OLE DB connection manager онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь goshedy 23 Декабрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,730 раз и оно понравилось 30 людям.