Updating ole ole
There are a number of differences between SQL Server Native Client and Microsoft Data Access Components (MDAC; starting with Windows Vista, the data access components are now called Windows Data Access Components, or Windows DAC).
Although both provide native data access to SQL Server databases, SQL Server Native Client has been specifically designed to expose the new features of SQL Server 2005, while at the same time maintaining backward compatibility with earlier versions.
Note: Performance can be improved if you use the ORDER option to sort the input data according to the clustered index on the table.
The Transact-SQL keywords are traditionally typed using uppercase letters, but the keywords are not case sensitive.
Note If you use the OLE DB Destination Editor dialog box in SSIS Designer to create the destination table into which the OLE DB destination inserts data, you may have to select the newly created table manually.
The need for manual selection occurs when an OLE DB provider, such as the OLE DB provider for DB2, automatically adds schema identifiers to the table name.
The OLE DB destination has one regular input and one error output.
For more information about data types, see Integration Services Data Types.
Note The OLE DB destination does not support parameters.Both options are available from the OLE DB Destination Editor dialog box.