SSIS: connection managers

Answer:


OLEDB connection - Used to connect to any data source requiring an OLEDB connection (i.e., SQL Server 2000)


Flat file connection - Used to make a connection to a single file in the File System. Required for reading information from a File System flat file

ADO.Net connection - Uses the .Net Provider to make a connection to SQL Server 2005 or other connection exposed through managed code (like C#) in a custom task


Analysis Services connection - Used to make a connection to an Analysis Services database or project. Required for the Analysis Services DDL Task and Analysis Services Processing Task


File connection - Used to reference a file or folder. The options are to either use or create a file or folder
Excel
FTP
HTTP
MSMQ
SMO
SMTP
SQLMobile
WMI

SSIS Interview Questions And Answers