Interview questions on SSIS

Posted by Siva.boggarapu under Sql Server on 4/15/2011 | Points: 10 | Views : 7743 | Status : [Member] | Replies : 2
Hello Guys,

Here below i posted some interview questions for SSIS(SQL SERVER INTERGRATION SERVICES)

1) What is the control flow
2) what is a data flow
3) how do you do error handling in SSIS
4) how do you do logging in ssis
5) how do you deploy ssis packages.
6) how do you schedule ssis packages to run on the fly
7) how do you run stored procedure and get data
8) A scenario: Want to insert a text file into database table, but during the upload want to change a column called as months - January, Feb, etc to a code, - 1,2,3.. .This code can be read from another database table called months. After the conversion of the data , upload the file. If there are any errors, write to error table. Then for all errors, read errors from database, create a file, and mail it to the supervisor.
How would you accomplish this task in SSIS?
9)what are variables and what is variable scope ?
Answers
For Q 1 and 2:
In SSIS a workflow is called a control-flow. A control-flow links together our modular data-flows as a series of operations in order to achieve a desired result.

A control flow consists of one or more tasks and containers that execute when the package runs. To control order or define the conditions for running the next task or container in the package control flow, you use precedence constraints to connect the tasks and containers in a package. A subset of tasks and containers can also be grouped and run repeatedly as a unit within the package control flow.

SQL Server 2005 Integration Services (SSIS) provides three different types of control flow elements: containers that provide structures in packages, tasks that provide functionality, and precedence constraints that connect the executables, containers, and tasks into an ordered control flow.

A data flow consists of the sources and destinations that extract and load data, the transformations that modify and extend data, and the paths that link sources, transformations, and destinations. Before you can add a data flow to a package, the package control flow must include a Data Flow task. The Data Flow task is the executable within the SSIS package that creates, orders, and runs the data flow. A separate instance of the data flow engine is opened for each Data Flow task in a package.

SQL Server 2005 Integration Services (SSIS) provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean data. Destinations load data into data stores or create in-memory datasets.

Regards,
siva,
skyme:siva.boggarapu.ef



Responses

Posted by: Chvrsri on: 4/15/2011 [Member] [Moderator] [MVP] Silver | Points: 25

Up
0
Down
Hi Siva.boggarapu ,

If you are interested in posting interview questions , kindly post it in interview section. Generally all users search for interview section questions at interview section. This section is meant to ask questions and make those questions get clarified. Hope you got my point.

Thanks,
Radha Srikanth

Siva.boggarapu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Siva.boggarapu on: 4/15/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Radha,

Thanks for your kind information. From next time onwords i will do same thing what suggest me.

Thanks,
Siva

Regards,
siva,
skyme:siva.boggarapu.ef

Siva.boggarapu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response