Ssis developer Interview Questions
29Ssis Developer interview questions shared by candidates
1.brief about your total experience 2.explain about your SSIS dev activities what you have done and packages you have developed 3.transformations used 4.different sources 5.SSIS package, all of the sudden not running, what could be the reasons, how do you troubleshoot to resolve this. 6. when working with excel as a source, what are the things we need to consider or things to remember?. 7.how will you implement error handling? 8.use of checkpoint and scenario you have used? 9.different kinds of SSIS deployments? 10.SSIS package running slowly, many transformations, how to identify the bottlenecks in the package. 11.materialized view1 Answers
I answered to my best of knowledge.
What is a configuration file and what do you use it for? Have you ever used an SSIS template? How do you troubleshoot a failed package?1 Answers
To make a package dynamic which makes to run on any server, we create a configuration file. Suppose we created a package in dev server and we are now deploying it to QA or prod. Then the properties like server names, databases names etc vary from one server to other. So inorder not going in everpackage change, we just change those properties in config file and we run package by adding that config file. Now same package runs on every server, just changing the properties in config file. We can create config file as XML, sqlsetver, registry,parent child or Windows event. We can troubleshoot an error in a package by searching the error codes in the execution page. Less
Name five SSIS tasks. Name three ways to execute an SSIS package. How do you account for errors in a package?1 Answers
The 5 tasks mostly used are execute SQL task, data flow task, send mail task, file system task, execute process task And the ways to execute a SSIS package are: Using dtexec.exe , dtexecui and from the Ssdt application, sqlagent etc To access for errors we can see the log files and if it is SSIS 2012 and plus versions, in the integration services catalog the log information is saved. Less