SSIS – Part 2
SSIS Interview Questions and Answers for Experienced and Fresher’s
Here we are publishing series of posts on SSIS Interview questions and answers Part 2 for experienced and freshers . Below is the series 2.
Q. What is a breakpoint in SSIS?
Ans:
A breakpoint is a stopping point in the code. The breakpoint can give the Developer\DBA an opportunity to review the status of the data, variables and the overall status of the SSIS package.
Breakpoints are setup in BIDS. In BIDS, navigate to the control flow interface. Right click on the object where you want to set the breakpoint and select the ‘Edit Breakpoints…’ option.
Q. Can you name 5 or more of the native SSIS connection managers?
Ans:
- OLEDB connection – Used to connect to any data source requiring an OLEDB connection (i.e., SQL Server)
- 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
- SQL Mobile
- WMI
Q. How do you eliminate quotes from being uploaded from a flat file to SQL Server?
Ans:
