You can set properties through SSIS Designer or programmatically.



You can log the calls that the OLE DB destination makes to external data providers.
You can use this logging capability to troubleshoot the saving of data to external data sources that the OLE DB destination performs.
The Transact-SQL keywords are traditionally typed using uppercase letters, but the keywords are not case sensitive.
To learn more about fast load options, see BULK INSERT (Transact-SQL).
The OLE DB destination loads data into a variety of OLE DB-compliant databases using a database table or view or an SQL command.