SSIS uses connection managers to integrate different data sources into packages. SSIS includes a wide variety of different connection managers that allow you to move data around from place to place. Table 1 lists the available connection managers.
ADO=Connecting to ADO objects such as a Recordset.
ADO.NEt=Connecting to data sources through an ADO.NET provider.
CACHE=Connects to a cache either in memory or in a file
MSOLAP100=Connecting to an Analysis Services database or cube.
EXCEL=Connecting to an Excel worksheet.
FILE=Connecting to a file or folder.
FLATFILE=Connecting to delimited or fixed width flat files.
FTP=Connecting to an FTP data source.
HTTP=Connecting to an HTTP data source.
MSMQ=Connecting to a Microsoft Message Queue.
MULTIFILE=Connecting to a set of files, such as all text files on a particular hard drive.
MULTIFLATFILE=Connecting to a set of flat files.
ODBC=Connecting to an ODBC data source.
OLEDB=Connecting to an OLE DB data source.
SMOSever=Connecting to a server via SMO.
SMTP=Connecting to a Simple Mail Transfer Protocol server
SQLMobile=Connecting to a SQL Server Mobile database.
WMI=Connecting to Windows Management Instrumentation data.
No comments:
Post a Comment