Database Reference
In-Depth Information
access to other applications and other databases. The ADO.NET layer quickly retrieves
data from the source using a DataReader object in the .NET Framework.
The ADO.NET connection manager for SQL Server is best used as a source when
you are using it elsewhere in the package. For example, the Lookup component uses an
ADO.NET connection manager to connect, so then you should use it as a source. On
the other hand, if a component uses another connection manager type, stick with that
connection manager type. Consistency is really the key here. For a sample connection
manager property window set to connect to the AdventuresWorks2012 database on the
same server, see Figure 4-2 .
Figure 4-2 . ADO.NET connection manager property screen
ODBC
 
 
Search WWH ::




Custom Search