|
|||||
|
|||||
|
Get Your Own BlogIf you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com. Contact the authorAll BlogsFeedsArchives for this blog
Devin Knight
Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).
SSIS Interview Questions
I have decided to make a short series of blogs about possible interview questions to help you prepare for an interview. Last time I wrote about basic DBA questions. Today I have given you some basic SSIS question to study. These basic SSIS questions will give you a starting point on how to prepare for an interview. If you have any other suggestions feel free to add to this list but keep in mind these questions are probably for a mid to junior level BI consultant. I would assume if you're a senior BI developer you know what to expect.
SSIS Interview Questions 1. What does a control flow do? 2. Generically explain what happens inside a data flow task? 3. Explain what ETL is? 4. Which task would you use to copy, move or delete files? 5. Which transform would you use to split your data based on conditions you define? 6. Explain the pros and cons of deploying to a file system vs msdb? 7. If you did not know the answer to a question what would be your next step to find the answer? CommentsLeave a Comment |
Subscribe to this blog
Briefcase
Print
Posted by rashmim on 8 April 2009
Can you please provide with some more SSIS interview questions at an adavnced level?
Posted by knight_devin@hotmail.com on 8 April 2009
Sure thing I'll come up with something
Posted by sharad14587 on 5 June 2010
i want some basic SSIS interview questions
can you please provide me ?
Posted by jaiready06 on 19 March 2013
Hello,
Can you please post me basic and advanced SSIS and SSRS interview questions.
Thank You