ADO NET Destination Editor (Connection Manager Page)
Applies To: SQL Server 2016
Use the Connection Manager page of the ADO NET Destination Editor dialog box to select the ADO.NET connection for the destination. This page also lets you select a table or view from the database.
To learn more about the ADO NET destination, see ADO NET Destination.
To open the Connection Manager page
In SQL Server Data Tools (SSDT), open the Integration Services package that has the ADO NET destination.
On the Data Flow tab, double-click the ADO NET destination.
In the ADO NET Destination Editor, click Connection Manager.
Select an existing connection manager from the list, or create a new connection by clicking New.
Create a new connection manager by using the Configure ADO.NET Connection Manager dialog box.
Use a table or view
Select an existing table or view from the list, or create a new table by clicking New..
Create a new table or view by using the Create Table dialog box.
Preview results by using the Preview Query Results dialog box. Preview can display up to 200 rows.
Use bulk insert when available
Specify whether to use the System.Data.SqlClient.SqlBulkCopy interface to improve the performance of bulk insert operations.
Only ADO.NET providers that return a System.Data.SqlClient.SqlConnection object support the use of the SqlBulkCopy interface. The .NET Data Provider for SQL Server (SqlClient) returns a SqlConnection object, and a custom provider may return a SqlConnection object.
You can use the .NET Data Provider for SQL Server (SqlClient) to connect to MicrosoftAzure SQL Database.
If you select Use bulk insert when available, and set the Error option to Redirect the row, the batch of data that the destination redirects to the error output may include good rows.For more information about handling errors in bulk operations, see Error Handling in Data. For more information about the Error option, see ADO NET Destination Editor (Error Output Page).
Technical article, Loading data to Windows Azure SQL Database the fast way, on sqlcat.com