Questions d'entretiens - Ssis developer


Questions d'entretien pour Ssis Developer partagées par les candidats

Principales questions d'entretien

Trier: Pertinence|Populaires|Date
On a demandé à un ETL/Ssis Developer...10 mars 2016

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 réponses

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. Moins


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?. 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 view

1 réponses

I answered to my best of knowledge.

Intellect Design Arena

Technical interviews were from RDBMS basics to all the details quoted in resume

1 réponses

Please have your basics covered before you go for the interview


Name five SSIS tasks. Name three ways to execute an SSIS package. How do you account for errors in a package?

1 réponses

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. Moins

Ness Digital Engineering

Tell me about your project?

1 réponses



How do you feel about change? Why do you want to work here?


Describe a day at work.


What types of BI tools are you familiar with/have you used?


1) Types pf containers?? 2) Merge Join in brief 3) Precedence constraints workflow. 4) Explain What Is A Checkpoint In Ssis?



1 - 10 sur 29 questions d'entretien d'embauche

Consultez les questions posées en entretiens pour des emplois similaires