The newly created data source OLEDB_AdventureWorks will show up under the Data Sources folder in the SSIS project. OLEDB denotes the connection type and AdventureWorks denotes the database name. On the final step, give a proper name to the Data Source like OLEDB_AdventureWorks. If you choose SQL Server Authentication, enter a valid user name and password.Ĭlick Test Connection to make sure that the credentials are valid.Ĭlick Next on Data Source Wizard. Select Windows authentication or SQL Server Authentication depending on how you would like to connect to the SQL Server instance. ![]()
0 Comments
Leave a Reply. |