.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What is the control flow & data flow in SSIS?

Posted By :Dhiraj Ranka     Posted Date :October 10, 2010    Points :10   Category :Sql Server 
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.

You can also find related Interview Question to What is the control flow & data flow in SSIS?  below: 

Difference of ASP and ASP.NET Security Flow

The security flow for ASP.NET page request is different from the classic ASP security flow. In ASP, IIS impersonates the authenticated user by default, and in ASP.NET, the developer has more control over configuring security at different level [2].

Shasi Ray (More...)

Can you edit data in the Repeater control?

No, it just reads the information from its data source. (More...)

What data type does the RangeValidator control support in Asp.net?

There are 3 Data type RangeValidator control support

3)Date (More...)

Which template must you provide, in order to display data in a Repeater control?

You have to use the ItemTemplate to Display data. Syntax is as follows,
< ItemTemplate >
< div class ="rItem" >
< img src="images/<%# Container.DataItem("ImageURL")%>" hspace="10" />
< b > <% # Container.DataItem("Title")%>
< /div >
< ItemTemplate >

What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

Set the DataMember property to the name of the table to bind to. (If this property is not set, by default the first table in the dataset is used.)
DataBind method, use this method to bind data from a source to a server control. This method is commonly used after retrieving a data set through a database query.

what is IMPERSINATE in work flow when we work on workflow in designer?

The default mechanism of running workflows as the person who initiates it presents some challenges when trying to implement some processes via workflows - e.g. copying a document to a confidential location that the person updating the document doesn't have permissions to.

Set Content Approval Status (as Owner)

Create List Item (as Owner)
Update List Item (as Owner

Delete List Item (as Owner
Add List Item Permissions (as Owner
Remove List Item Permissions (as Owner
Set List Item Permissions (as Owner
Inherit List Item Permissions (as Owner) (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend