Overblog Follow this blog
Administration Create my blog
February 9 2017 5 09 /02 /February /2017 09:02
In this article we will learn how to connect “Foreach Loop container” with “Execute SQL Task”. Starting with the practical, do a drag and drop of “Foreach Loop container” on Control Flow pane from SSIS Toolbox as shown in the below screen shot…
 

 
Now go to the “Foreach Loop Container” and double click. Go to the “Collection” and select the “Enumerator” under the Foreach loop editor. Then select the option that is “Foreach ADO Enumerator”. We want loop over the object which contain indivisible row of our table that is loop over dataset. In that case we will tack “Foreach ADO Enumerator”. After that select the “Rows in the first table” because we have only one table. We select the “Rows in the first table”. Then select the variable name. It sees the below screen shot…
 

This “Foreach ADO.NET Schema Rowset enumerator” when you want to detail about “Schema”. We want to find how many tables are there in particular database in that case we will use this option.

Then go to the “Variable mappings” and create the three “VARIABLE”. In order to that go to the variable say <new variable...> as see the following screen shot…

Now put the “variable name” that is “SSISEmpId”, variable “value type” that is “Int32” and variable “Value” that is “0”. Variable “Name” created for the “EmpName” and “EmpAdd” that is “SSISEmpName” and “SSISAdd”. Same value type for the “EmpName” and “EmpAdd” that is “String”.

 
 
When we configure the “Variable” you can see the “Variable” and “Index”. Allowge remember that “Index” start with a “Zero(0)”.you can see the below screen shot…
 

 
Insert each of the record into the database for that you will need one more “Execute SQL Task” but this SQL Task places inside the “Foreach Loop Container” as see the below screen shot…
 

 
Before the configure “Execute SQL Task” we need a variable. In order to that go to Control Flow and right click say “Variable” and configure as see the below screen shot…
 

 
Then configure the “Execute SQL Task” go to the “ConnectionType” say “ADO.NET”. Then select the Connection are “Destination Database Name” and this time “SQLSourceType” we will tack “variable”. Than go to the “SourceVariable”, that is newly created variable as see the below screen shot…
 

 
Then go to the “Parameter Mapping” and “Add” three Parameter. First is “SSISEmpId”. Second is “SSISName” and third one is “SSISAdd” and parameter Name is “EmpId” , “EmpName” and “EmpAdd”. SSISEmpId, SSISEmpName and SSISAdd are SSIS variable and EmpId, EmpName and EmpAdd are the SQL Parameter Name as see the below screen
shot…

 
When you configure the “Parameter Mappings” than click OK and run the application as see the below screen shot…
 

 
Error says that variable employee data does not contain a valid data object as see the below screen shot…
 

 
Error says that “Execute SQL Task” execute and successfully complete. Than Foreach loop try to execute it fail because “Foreach Loop Container” execute before execute “Execute task” complete it executing and because of that when “Foreach Loop Container” try to execs employee data variable it empty. “Foreach Loop Container” only after “Execute SQL Task” complete his executing that is help of “president constrain”. Connect that “Execute SQL Task” to the “Foreach Loop Container” as see the below screen shot…
 

 
Than rerun the application as see the below screen shot…
 

 
This error says that “Insert query Fail because failed to convert Parameter value from a string to a Int32”. Then go to Control Flow and “Stop” the execution and go to the “Execute SQL Task” which is inside the “Foreach Loop Container”. Then go to Parameter Mapping and change the Data Type of “SSISEmpName and SSISAdd” into the Int32 to String as see the below screen shot…

 
Than run the application as see the below screen shot…
 

 
See the result in SQL as see the below screen shot…
 

 
Also follow below MSBI project series video which will teach practical starting from SSIS: -
 
Repost 0
February 1 2017 4 01 /02 /February /2017 09:35
Over here issue is that SQL table containing duplicate value which in actual it should not have that.
 

We have an error see below screen shot…
 
This is the Error…
 

 

In order to that, first go to the “Data Flow” and drag “Aggregate” component into the “Data Flow” design pane as shown in the following screen shot…

 

Now configure the “Aggregate” component as the following screen shot…

 

 
Also drag and drop “Sort” Transformation component into the Data Flow design pane. This Component place inside the “Common” and configure. Sort transformation place between the “Aggregate” and “Pivot” and connect to them as see the following screen shot…
 

 
When you configure the “Aggregate” and “Sort” than run the application as see the following screen shot….
 

 
Output gets sorted and is displayed in the following image

 
To start practically SSIS project below is one nice start-up MSBI video: -
 
Repost 0
January 31 2017 3 31 /01 /January /2017 11:57
This write-up will do a quick discussion on two errors and will propose solution for it while working on SQL Server agent.
 

Error 1:-

Now when we tried to create a Job in our SQL Server agent to run our XMLA query and for processing the cube in the background, there were some errors which was encountered by student of MSBI training during practical lab in recent time.
 

 
Next click “SSASJob” and then do right click on “View History”

 
Below is Log File Viewer and in that error details are mentioned
 

 
 
Here the error says that the syntax is incorrect.
 

Solution 1:-

 

For getting the solution to this error is that, we have to see where we have done the mistake while creating the Job.
 
So go to our Job and right click it and then go to the properties option.

 
Now in the properties we go to the Steps and see the step which we have created. We have to double click the step which we have created so that we can edit it.
 

 

 
Here we see everything is correct in our Job but the error is at the selection of type. We have
selected “SQL Server Analysis Services Query” which is wrong because the XMLA query which we want to execute is actually a command. So we just have to change the type.
 

 
After that is done we select OK and then try to run our job once again.

 
Once clicked you will see Start Jobs window.

 
Our Job will run successfully.
 

Error 2:-

 

Now the above error is solved still there are some errors which are remaining.

 

Below is the error details

 
Here the error says that our SQL server Agent does not have permission to process our Cube.
 

Solution 2:-

 

Now for solving this error we have to provide permission for processing the Cube. To provide permission we have to create a new Role and define the permission for the Cube.

 
Do right click on Roles > New Role…
 

 
It will open Create Role window then click “General” tab option available at the left
 

 
Next click on “Membership” tab option available on the left side

 
Next it will open Users or Groups window as shown in the image down below under it set NT SERVICE\SQLSERVERAGENT
 

 
Now once again try to run the job and see what happens.
 

 
We can see the permission of the user which was needed for running the Job.

 
Now the Job is running successfully. Some candidate of MSBI training are smart chaps resolve query on their own while some stuck up when they do practical faculty’s constantly strive to make them learn topic and help them to resolve their query which make training successful.
Below is practical learning video for SSIS to start with MSBI project: -

Repost 0
January 25 2017 4 25 /01 /January /2017 12:36
What work does CDC do in SQL Server?
  • CDC means Change Data Capture. The main work of CDC in SQL Server is that it keeps track of all the Inserts, Updates & Deletes happening on a particular Table or on a Particular Database.
What is the importance of “_CT” table in CDC in SQL Server?
  • The “_CT” table indicates or keeps track of all the Insert, Update & Delete occurring in the individual table.
  • For example cdc.dbo_tblCustomer_CT is a table which tracks the Insert Update & Delete in this tblCustomer table.
How the CDC does denote the Insert, Update & Deleted states?
  • Now CDC helps in tracking the insert update and delete, but has its own way of denoting the insert update and delete.
1 - It indicates Delete
2 – It indicates Insert
3 – It indicates values before the Update
4 – It indicates values after the Update
 

 
 
 
 
 
 
 
 
 
 
 
Does CDC do Incremental or Full Load?
  • CDC always does an Incremental load because it will track the Changes happening in the Database or the table and then load only those changes in the destination which is also called as Incremental load. This incremental load is very useful when we have large number of records and it is very difficult do the Full Load every time there is a Change in Data. Therefore CDC does Incremental Load.
What are the 2 different phases in the CDC load?
  • CDC load has two very important phases known as Phase 1 & Phase 2.
  • Phase 1: Phase 1 is where we will load the data from the Source to the Destination one time only and these data will be the new loaded data and also the Changed data. This is also known as Snapshot loading because the data directly goes from the source to the destination.
  • Phase 2: Phase 2 is where now the data will not be loaded from the source but now the data will be loaded from the CDC file which will have all the changes that are tracked like the inserts, updates, deletes. And then every time the changes will happen from that CDC file. Only for the First time the data will load from the source to the destination.
What is the importance of the cdc_states table?
  • Now a cdc_states table is created to make sure it keeps track of when our Phase 1 and Phase 2 has started and ended.
  • It will keep a track of when the CDC process has started and when it has ended.
How is CDC different from SCD?
  • Now CDC and SCD both do almost the same function but there are some pros and cons which have to be considered when we are applying it in our project.
  • Here is a small difference between the CDC and SCD.

 

  1. If the source is SQL server then both CDC and SCD can be used.
  2. But if the source is non SQL server then CDC cannot be used because it is a part of SQL Server.
  3. If we want to keep History of the Changes with the Data the CDC cannot be used. For that we have to use the Type 1 & Type 2 of SCD.
  4. If we want to do the Incremental load the CDC can be used because it loads only those records that have been changed.
  5. If there are large records the CDC must be used because it does incremental load, whereas SCD cannot be used it does Full Load and for larger records Full Load will be Time Consuming.
Refer to below SSIS video which demonstrate start-up of the project: -
Repost 0
January 24 2017 3 24 /01 /January /2017 13:10

Now in analysis services there is a Cube which contains both Dimension and Measure group data. But the important thing in this Cube is partition. Now basically we can say that partitions are nothing but simple object present inside the Cube which holds the complex measure group data. It is like having sub container inside the Cube which we can call it as big container which contains Dimension data and small partitions having measure group data.

 

 

These partitions do not have to be created manually but they get created when Cube gets created, dimensions and the partitions are loaded with data from data ware house when Cube gets processed.

 

So if we take an example we can see that there a Fact table called “FactCustomer” and only 1 partition is created when Cube got created.

 

 

Here we can see the one partition created.

 

What is the need for Partitions?

 

Now usually in small examples when we want to load data into the Cube from our Data warehouse we simply process the Cube. It means we go to our Solution Explorer right click and then select process option which will process the Cube.

 

But processing all the records from our Fact table is not feasible for large database in real time scenario. In the production environment there millions and billions of record and every time processing them will take a very long time. It means that processing Cube means processing our data warehouse again and again.

 

So now in real time to make this work faster we will deploy the Cube and process it for the first time and then after that in future whenever we want to refresh the Cube or process the Cube for new data, we will not process the whole Cube but we will process parts of Cube which are necessary. For instance we can process the dimensions individually.

 

 

So therefore we need partitions in our cube to keep the measure data, so that for large data warehouses we can simply process only those partitions which are needed and that will make our work faster and performance will increase.

 

Partitions contain mainly measure group data. And in real time environment Facts or measure groups are processed more that the dimensions because dimensions are masters and no one will change the masters every day whereas facts are changed every day so Facts or measure group data are processed more frequently.

 

Different Deployment options with Processing:

 

Now usually when we deploy the Cube after the deployment it asks us to process the Cube. Now for large data records it will be very difficult to every time process the Cube. So while deploying we have three kinds of options. We can set those options according to the various real time scenarios.

 

The three processing options after the deployment are:

  • Default
  • Do Not Process
  • Full

Now we will understand one by one what these options mean.

 

Full option means that whenever we deploy the Cube processing will happen after deployment. It means every time the deployment will be continued by processing.

 

Do Not Process option means the Cube will not process after deployment. It means that every time we deploy the Cube it will not be continued by processing. So for processing the Cube or the individual partition or dimension we will have to explicitly select the option of process and do processing. In real time projects this Do Not Process option is the best as we have to manually deploy and process the Cube separately.

 

Default option means that if the Cube is already processed then don’t process it and if the Cube is not processed then process it.

 

But as a best practice in industry we will use the option Do Not Process.

 

Now how to select these options, here is the guide:

 

 

Below is the image snapshot where under Deployment tthere are three processing option “Default”, “Do Not Process” and “Full”. This specifies whether Analysis services object should be processed when the project is deployed.

 

 

Below is the MSBI video which covers how to start with SSIS project: -

 

Repost 0
January 23 2017 2 23 /01 /January /2017 11:37
Script Component can be used in 3 major ways, they are, As a Source, as a Destination & as a Transformation.
 
Now while doing the Script Component tasks and Script Tasks the most important thing is that we are using C# code to do it. We are using C# code because we want to do customize ETL and Non ETL activities.
 
So here are the sample C# codes which are used for doing Script Component tasks as a Source, Destination & Transformation.
 

Script Component as a Source:

 
To use Script Component as a Source we will write a C# code. First of all we will create a Customer Class and define the properties coming from the Source file.
 

 
public class Customer
    {
        public string CustomerName { get; set; }
        public string CityName { get; set; }
        public string StateName { get; set; }

    }
Then after that we go to our Main.cs file and write the logic.
 

 
Below is the C# code for Script Component used as a Source.
 

 
public override void CreateNewOutputRows()
    {
        string FileContent = File.ReadAllText("D:\\My Test
Work\\SSISCustomer\\SSISCustomer\\CustomerJSON.txt");

        JavaScriptSerializer ser = new JavaScriptSerializer();
        List Customers = ser.Deserialize>(FileContent); 

        foreach(Customer cust in Customers)
        {
            CustomerDataBuffer.AddRow();
            CustomerDataBuffer.CustomerName = cust.CustomerName;
            CustomerDataBuffer.StateName = cust.StateName;
            CustomerDataBuffer.CityName = cust.CityName;
        }
        /*
          Add rows by calling the AddRow method on the member variable named "Buffer".
          For example, call MyOutputBuffer.AddRow() if your output was named "MyOutput".
        */
    }
 
Next we will see Script Component working as Transformation.

Script Component as Transformation:

 

In Script Component as Transformation we already have a simple Source and Destination coming from our database. The Customization of the Source data, that is where Script Component is used.
 

 

















public override void CustomerInput_ProcessInputRow(CustomerInputBuffer Row)
    {
        string Address = Row.Address;
        string[] AddressParts = Address.Split(',');

        string CityName = AddressParts[0];
        string StateName = AddressParts[1];

        Row.CityName = CityName;
        Row.StateName = StateName;
        /*
         * Add your code here
         */
    }
 
So this the C# code for Script Component used as a Transformation.
 

Script Component as Destination:

 
For writing the C# code as Script Component used as destination we need to again create a Customer class and then write the main logic in our Main.cs class.
 

 
namespace ScriptDestinationTask
{
    public class Customer
    {
        public string CustomerName { get; set; }
        public string CityName { get; set; }
        public string StateName { get; set; }
    }
}
 
Now we write the logic in Main.cs

 
Specify the location where Destination needs to be stored as shown in the image down below.
 

 
List Customers = new List();
    public override void PostExecute()
    {
        JavaScriptSerializer ser = new JavaScriptSerializer();
        string Json = ser.Serialize(Customers);

        File.WriteAllText("D:\\My Test Work\\SSISCustomer\\SSISCustomer\\NewJson.txt", Json);
        base.PostExecute();
        /*
         * Add your code here
         */
    }
 

 
public override void Input0_ProcessInputRow(Input0Buffer Row)
    {

        Customer cust = new Customer();
        cust.CustomerName = Row.CustomerName;
        cust.CityName = Row.CityName;
        cust.StateName = Row.StateName;

        Customers.Add(cust);
        
        /*
         * Add your code here
         */
    }
 
In this way C# code can be written for Script Component used as Source, Transformation & Destination.
 
Below is MSBI video which fresher will love it which will help them to build SSIS project right from scratch: -

Repost 0
January 17 2017 3 17 /01 /January /2017 07:50
While working with Merge component in SSIS project below is the error got while configuring the component. Here the error is Short key position of the both the input are not organised properly as Shown in below screen shot.
 

 
Solution
 
Merge component expect that input which come to the merge component should be shorted. Right click on the “Flat File Source” and go to the “Show Advanced Editor” than click to “input output properties”. After that select the “Flat File Source output” into the “Input Outputs” block. We want to output will short so, the “IsShorted” is “True as Shown in below screen shot…
 
File 001 is coming to the Flat File Source and other is coming to the SQL Server.

 
Than defined Short key position, the first short key mains “Name” is 0 and other Short key “Amount” is 1 as shown in below screen shot…
 

 
In the same way, go and configure the “Flat File Source 1”.
 
Than go to merge component and say Edit as Shown in below screen shot…
 

 
Then connect the “Merge component” to “Flat File Destination” file and configure it. Right click on the “Flat File Destination” file and Edit. Open “Flat File Destination Editor” window and create the new connection manager. Then click to “Browse” and create the file Name and location of file. Now check the box which indicates the “Column name in the first data row” and click to “OK” as Shown in below screen shot…

 
OUTPUT
 
After running SSIS package now you will see green mark on the top of each component as shown in the image down below.

 
And following is the output shown on the text file which can be found in the folder of your local hard drive.
 

 
 
Following is the video on SSIS, SSAS and SSRS project series. This series covers almost every aspect of MSBI programming
 

Repost 0
January 12 2017 5 12 /01 /January /2017 08:34
Problem is that if I go and run the project there is exception.
 
Under “Main.dtsx” design, there is error in the Country master and go to the “country.dtsx” design to check the Error. You can see RED cross mark on top right of the component. In the RED sign some error message here. It sees the following screen shot
 

 
Message says that, I can’t insert the duplicate key in the “Country” table. Because the “Country Table” as well as ProductTable, SalesPersonTable and StateTable all have a primary key. Re-run the package you try the re-load the data inside the table. While using SQL tables in MSBI duplicate data can occur for analysis or business sake so primary key can be disabled.
 
Solution
 
We need to go to the SSIS Toolbox➝ common➝ Data Conversion. Drag and drop the “Data Conversion” into the “Data flow” and Edit the “Data Conversion” as following screen shot…
 
We have a component in SSIS called as “Slowly Changing Dimension”. Slowly Changing Dimension is Available in the data flow task. Go to the SSIS Toolbox➝ Common➝ Slowly Changing Dimension.
 
Double Click on SCD will initiate Slowly Changing Dimension Wizard
 
Slowly Changing Dimension will right, all the logic as well as go and connect the SQL Server.
 
Drag and drop the Slowly Changing Dimension in Data flow and right click in the Slowly Changing Dimension say “Edit”. Click on the edit its start wizard and wizard helps us to configure Slowly Changing Dimension component. It sees following Screen shot…

 
When we click on the “New” then pop up new windows to configure the “Connection Manager”. It sees the following screen shot…
 

 
Select the “Input Columns” which is defined into the “Data Conversion”. Defined the “Dimension Columns” and “Key Type” is “Business key”. Business key is the primary kind of the think and then next. See the following screen shot..
 

 
Now, the Slowly Changing Dimension Wizard gives you three kinds of option.
  1. Fixed Attribute ➝ Fixed attribute changing indicate the column value must not change. For which value is not change.
  2. Changing Attribute ➝ Changing attribute changes overwrite records. This kind of change is equivalent to a Type 1 change.
  3. Historical attribute ➝ Historical attribute changes create new records instead of updating existing ones. It is also called Type 2 change. In Type 2 change is maintain.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
You can check or uncheck as per your requirement, I am un-checking these two.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Also un-check the “Enable Inferred Members Support”.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Click to “Next” and finish.
 
With the removal of primary now working with SCD component will be absolutely fine.
 
Below is “Learn MSBI in 32 hrs” series project starter video to learn more topic: -

Repost 0
January 7 2017 7 07 /01 /January /2017 07:37
For loop container loops a constant value.For Loop is a NON-ETL activities and that code has to be done in control flow. For loop container loop till a fixed count.
 
For Loop container groups set of tasks together and allows you to looping through the tasks in your package which is similar like for loop in any programming language. In case until a fixed count than you will use the “For Loop container”.
 
Drag and drop For Loop container from tool box on to Control flow design editor as shown in
 
 
Double click on For Loop container task which takes us to configuration editor as shown in
 
 
Configuration editor has only two options For Loop and Expressions.
 
InitExpression: This will initialize the loop with specified values
 
EvalExpression: specifies an expression to stop the loop when the expression evaluates to false. This expression must evaluate to a Boolean.
 
AssignExpression: specifies an expression that changes a condition in the same way each time the loop iterates.Which is optional one.
 
Drag and drop “For loop” container and configure as shown below
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
When we use For Loop Container task.
 
For Loop Container Task: When we know the exact how many times we have repeat given data flow for execution.
 
Difference between For Loop and Foreach Loop Container?
 
A For Loop container loops till a constant value. So for example if you want to loop until a value is 12 or less than 12 so for upto fixed count you have to use For Loop container.
 
Whereas Foreach Loop container loops through collection so this collection can files in a folder or collection can be in record set.
 
Foreach loop
 
Foreach loop container actually loop through a collection. Now this collection row in a record set files in a folder.
 
For Each Loop Container Task: When there is dependency of number of time task should execute on data such as files, variables we will use this.The Foreach Loop container defines a repeating control flow in a package. The loop implementation is similar to Foreach looping structure in programming languages. In a package, looping is enabled by using a Foreach enumerator. The Foreach Loop container repeats the control flow for each member of a specified enumerator.
 
Step 1
 
Create a source folder (I have created Folder Named Customer) containing some text files and create Destination Folder where you want to copy these files.
 
 
 
 
Step 2
 
First, we need to create an ETL process for a single file. So, create an ETL process for single file.
 
Step 3
 
After that ETL Process is completed now to make it easy we will save both File to a folder Called “Bulkfile”.
 
 
 
Step 4
 
In this step on “Control Flow” tab we will create a variable why because if you see on “Data Flow” tab pue source in Flat File Connection we have physical file name is “CostomerSales.txt” which is one single file name. Weworking with multiple files. We will create a variablein “CONTROL FLOW” tab and pass that full file name through this variable name to “DATA FLOW” using “Foreach loop”.
 
 
 
Variable
 
It is temporary stores. We go and store some value.
 
Create a variable.
 
In order to create a variable go to Control Flow Right Click  Add Variable as Shown in below screen shot.
 
 
Add variable and give the name and then we are passing file name so our variable data type should be “String” as shown in below screen shot..
 
 
We will configure FOREACH LOOP container. Select container and right click -->edit.
From left-hand side menu select collection and from enumerator select "FOREACH FILE Enumerator".
 
Go to below in the folder section folder path "rahulxadfg" which we have created earlier and below that give extension as ".txt" since our data is in text format as shown in below screen shot…
 
 
Select Variable mapping from left-hand side and choose variable name which we have created earlier i.e. "VarFullFilePath" as shown in below screen shot…
 
 
Everytime "FOREACH FILE Enumerator" loops and get a file it will assign that file path to this variable "VarFullFilePath".
 
After that we configure the Data Flowtable at source. Where file name is needed for ETL process.
 
So go to Data Flow tab and  Connection Manage  right clicks on CSV Connection Manager  Properties.
 
In the properties window if you see current "ConnectionString" it consist of single file path that we want to make it dynamic by assigning "VarFullFilePath".
 
The same property window there "Expression" menu -> configure -> click. In the property select "ConnectionString" and click on expression select variable "VarFullFilePath" and drag it to expression and click on OK as shown in below image.
 
 
Run this project to see the outputbelow is the screen shot on Control Flow.
 
And here is the screenshot from Data Flow.
 
 
Hope that practical of looping in SSIS is understood.
 
 
Do not forget to see following one such video from project series of MSBI(Microsoft Business Intelligence) for newbie’s: -
 

Repost 0
January 6 2017 6 06 /01 /January /2017 14:07

What is different between variable and parameter?

 

Variable is more internal to SSIS. Variable is used to pass the variable from control flowto data flow.

 

Variable

Parameter

They help to pass data from control flow to data flow.

They are passed from outside and help during deployment in production server.

They are just written with simple name as given.

They are denoted with $ symbol by the name.

They are more internal to SSIS application to pass data.

They are more internal to SSIS application to pass data.

 

Using Parameters with SSIS deployment

Parameter

 

Parameter is more external these are passing from outside.

 

Parameters allow you to assign values to properties within packages at the time of package execution.

 

Now we will create a parameter for destination path. So we will go back to project and add parameter as shown in below screen shot…

 

 

 

 

Click on parameter tab and add new parameter for destination path as shown in below image.

 

If you see we have created a string type parameter called "BulkFilePath" to set destination value which we have already set in the value.

We will configure this parameter to destination file connection in the connection manager. Right click on that “CVS Connection Manager” and go to property à choose expression.

We need to specify a property as ConnectionString because we want to parameterize our connection and then choose expression as shown in following screen shot….

 

 

Expression:- it is help set parameter and variable name values to the properties. To click on the Directory and set a parameter ($Package for parameter which is represent by $) and “VarFullFilePath” is variable.

 

helps you set variable of properties of SSIS component from variable and parameter”.

 

Right click on that “ Foreach Loop Container” and go to “Edit” as shown in following screen shot….

 

 

 

The parameter value will be set during deployment in production.

 

Hope that variables and parameters used within SSIS is understood.

 

Below see one video from project series of MSBI (Microsoft Business Intelligence)-

 

Repost 0

Important .NET and C# interview questions and answers

.Net interview questions: - Explain why it is not preferred to use finalize for clean up?

.Net interview questions: - Show the five levels in CMMI?

.NET interview questions and answers: – Which is the best place to store connection string in .NET projects?

C# interview questions and answers: – Explain the use of Icomparable in c#?

C# interview questions: - How can we check which rows have changed since dataset was loaded?

C# interview questions and answers: - Can you write a simple c# code to display Fibonacci series?

.NET interview questions and answers: - What is difference betweenIcomparable VS Icomparer ?

C# and .NET interview question: -What is short circuiting in C#?

C# and .NET interview question: - What are symmetric and asymmetric algorithms?

Important c# and .NET interview question on object pooling and Gridview events?

.NETinterview questions and answers: – Will the finally run in this code?

How to prepare for c# and .NETinterviews?

C# and .NET Interview questions: - What is Thread.Join () in threading?

.NET Interview questions and answers: -What is serialization and deserialization in .NET?

C# and .NET interview question: - What is hashing?

c# and .NET interview question:- what connects dataset and data source ?

.Net interview questions and answers: - What is the difference between “Web.config” and “Machine.Config”?

.NET interview questions and answers: - What is TPL?

.NET Interview questions and answers: -What are different access modifiers?

.NET and c# Interview Question and answers: – If we want to update interface with new methods, what is the best practice?

 MVC ( Model view controller) interview questions and answers      

ASP.NET Application and Page Life Cycle 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage) 

 6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

 

 

 

 

MVC Interview questions videos

Viewdata,viewbag,tempdata

 

MVC asynch controllers

What is View Model in ASP.NET MVC?



ADO.NET interview questions videos



Explain ADO.NET Connection pooling

 

 

Windows Phone Application Questions Videos

 

How to create a simple windows phone application ?

 

 

MVC Interview questions and answers Article

 

(Model view controller)MVC Interview questions and answers

MVC interview questions with answers video: – What is Web API how to implement the same?

ASP.Net MVC  4 interview questions with answers: - What is Bundling and minification in Model view controller ?

MVC interview questions with answers :- Is it possible to return values instead of Actionresults?

MVC interview questions with answers :- What are the actionresults available in MVC?

MVC interview questions with answers:-Html.PartialvsHtml.RenderPartialvsHtml.RenderPage in MVC

MVC ASP.NET INTERVIEW QUESTIONS WITH ANSWERS :- WHAT IS THE DIFFERENCE BETWEEN VIEWSTATE VS VIEWDATA ?

MVC vs ASP.NET ( MVC Interview question with answers )?

How can we detect that a MVC controller is called by POST or GET ? ( ASP.NET MVC Interview questions with answers)

What are the different ways by which you will get Form Data in controller? ( MVC Interview questions with answers)

What is the difference between Presenter and Controller in MVC?(MVC interview questions with answers)

Learn MVC (Model view controller) Step by Step in 7 days – Day 4

MVC Interview questions and answers PDF

MVC interview questions with answers

ActionResult vs. View() vs. ViewResult :- MVC interview questions with answers

Explain Areas in MVC?( MVC interview questions with answers)

Can you explain the purpose of ViewModel in MVC?( ASP.NET MVC Interview questions with answers)

ASP.NET MVC interview questions: - What are Filters in MVC?

What are areas in MVC?( MVC Interview questions with answers)

Explain the concept of View Model in MVC?

Exception Handling in MVC

Explain MVC application life cycle?


100 MVC Interview question PDF download released , Enjoy


Learn Microsoft Business intelligence step by step – Day 1


Can you create TempBag just like ViewBag?( MVC Interview questions)


MVC Unit Testing Unleashed

MVC and .NET learning tutorials for components of MVC and how do you perform unit testing in MVC?

Explain MVC model binders ? ( ASP.NET MVC interview questions)

Explain the difference between layout and master pages ? (MVC Razor interview questions)

Advantages of ViewModel in MVC(Model View Controller)

Difference Between ViewResult() and ActionResult() in MVC ?

What is the difference between each version of MVC 2, 3, 4, 5 and 6? (MVC Interview Questions)

Learn ASP.NET MVC 5 Step by Step in 30 days – Day 1

Can we overload MVC controller action methods ? (MVC Polymorphism) 

Can we overload Actions / Controllers in MVC? (MVC Interview questions)

 


WCF Interview questions videos

 

overloading in WCF

WCF fault exceptions ?

 

 

 

 

WPF Interview question with answers videos

 

Why WPF and compare WPF with Winforms ?

 

 

C# Interview Questions & Answers Article

 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage)

6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

C# (Csharp) interview questions and answers: – What are indexers in .NET?

C# OOP interview questions and answers: - I do not want to implement all the interface methods?

C# design pattern (UNIT of Work Design Pattern)

C# design pattern interview questions – What is Dependency injection ?

C# interview questions and answers: - What is the difference between “==” and .Equals()?

How questions are asked in c# interviews?

C# design pattern interview question: - DI vs IOC

8 important C# Interview questions on IL code, JIT, CLR, CTS, CLS and CAS

What is the difference between Reflection and Dynamic in C#?

C# and .NET interview question: – When should we use Structure as compared to classes
?

C# REST interview questions with answers asked in Polaris Hydrebad

c# threading interview questions :- Parallel.ForEach vs Task.Factory.StartNew

C# circular dependency interview questions with answers.

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

C# and .NET interview questions with answers: - How can we mark a method as deprecated?

C# INTERVIEW QUESTIONS WITH ANSWERS: - HOW TO ASSIGN MULTILINE STRING IN VISUAL STUDIO?

What is cyclomatic complexity (C# testing interview questions with answers)?

Define code coverage? (C# unit testing interview questions with answers)

Can you talk about Abstraction and Encapsulation in detail ? ( .NET, c# and OOP interview questions with answers )

Can you explain a practical example of virtual and Override? ( C# OOP interview questions with answers )

Can you explain class and object in real time scenario? ( C# and .NET OOP Interview questions with answers)

What is code digger ? ( C# visual studio interview questions with answers)

C# Lazy loading interview questions with answers

What is eager loading in c# ( C# eager loading interview questions with answers)?

Can you explain the term concurrency? (C# Interview questions with answers)

10 important C# Constructor and destructor interview questions

3 important c# Partial class interview questions with answers

Change Functionality without changing function( C# Architecture interview question with answers)?

What is ENUM and what are the benefits of using it (ENUM C# Interview Question 1)?

How can we loop through ENUM values( C# ENUM Interview questions with answers)?

What is the difference between Connection Timeout and Command Timeout?( C# ADO.NET Interview questions with answers)

How you differentiate Shadowing with Overriding? (C# overriding interview questions)

C# date and time interview question with answers

Explain the difference between early binding and late binding? ( C# interview questions with answers)

How can we restrict types in generics ?( C# generic interview questions)

What are generics, Delegates and Generic delegates ( C# interview questions)?

How can we convert JSON string in to c# object?(  C# JSON interview questions)

C# and .NET interview questions asked in TCSwalkin.

C# and .NET interview questions on Coalescing operator.

String vs string ( C# interview questions with answers)

Explain SOLID principles (C# Architecture interview questions)?

C# and .NET interview questions around Read only and Constant

C# Architecture interview questions with answers

C# Mock testing interview questions and answers: – What is Mock testing and how can we implement Mocking?

Write a simple regex for email validation? (C# interview questions with answers)


C#.NET interview questions: - What is the use of “Yield” keyword? Mention atleast one practical scenario where it can be used?

C#.NET interview questions: - What is the difference between Build Vs Rebuild Vs Clean solution menu? What is the difference “Rebuild” and if you do “Clean” + “Build”?

C# and .NET interview questions around JIT and NGEN


What is the difference between throw vs throw ex ?( C# Interview questions with answers)

C#/.NET interview questions: - What are the steps included to get a collection of records from database in C#?


Learn C# in Hindi video tutorials


QuestPond’s real life examples on Extension methods and nullable types in C#.NET


Why Microsoft has partial classes and Java does not?

 

 

 

WCF INTERVIEW QUESTIONS AND ANSWERS ARTICLE

 

 

WCF INTERVIEW QUESTIONS AND ANSWERS: - WHAT IS THE DIFFERENCE BETWEEN SERVICE ENDPOINT AND CLIENT ENDPOINT

 

WCF INTERVIEW QUESTIONS WITH ANSWERS: - WCF REST VS. WEB API

 

WCF INTERVIEW QUESTIONS WITH ANSWERS :- CAN WE HAVE METHOD OVERLOADING WHILE DEFINING WCF SERVICE OPERATIONS ?

 

WCF INTERVIEW QUESTIONS WITH ANSWERS :- WHAT IS DATACONTRACTSERIALIZER AND HOW IT’S DIFFERENT FROM XMLSERIALIZER 

What is SOA and what is WCF? ( WCF interview questions with answers)

Six important WCF interview questions with answers

6 important WCF Instancing interview questions with answers

WCF Service metadata interview questions with answers

7 WCF SOA interview questions with answers

What are the various ways of consuming WCF services?(WCF C# interview questions with answers)

What is the difference between Serialization and Encoding in WCF?( WCF interview questions with answers)

Why returning dataset or data table from WCF service is not a good practice?(WCF service interview questions with answers)

WCF transaction interview questions: - How transaction works in WCF?

WCF Transaction interview questions.

.NET WCF(Windows Communication Foundation) interview questions: - Distinguish between Web Services and Remoting | WCF and Web services

WCF interview questions: - What exactly do you mean by Single in WCF instancing? How to set and what is by default set value of instance context mode?

Explain WCF Duplex services? ( WCF Interview questions)

QuestPond: Interview Questions and Answers on learning WCF

WCF Interview Questions: - What are the different ways of doing WCF concurrency and WCF instancing?

QuestPond: Interview Questions and Answers on learning WCF (Windows Communication Foundation)

QuestPond: Interview Questions and Answers on learning WCF (Windows Communication Foundation)

QuestPond: Interview Questions and Answers on WCF(Windows Communication Foundation)

QuestPond: Interview Questions and Answers on learning WCF (Windows Communication Foundation)

QuestPond’s Interview Questions & Answers on learning data contract serializer and XML serializer

QuestPond’s Interview Questions & Answers on learning serialization events

QuestPond’s Interview Questions & Answers on learning WCF(Windows Communication Foundation)

QuestPond’s Interview Questions & Answers on WCF(Windows Communication Foundation)


QuestPond’s Interview Questions & Answers on WCF(Windows Communication Foundation)

QuestPond’s Interview Questions & Answers on WCF (Windows Communication Foundation)


QuestPond’s Interview Questions & Answers on WCF (Windows Communication Foundation)

 

 

 

WPF Interview Questions And Answers Article

 

 

6 IMPORTANT WPF AND SILVERLIGHT MULTI-THREADING INTERVIEW QUESTIONS WITH ANSWERS

 

C# WPF INTERVIEW QUESTIONS::- WHAT ARE DEPENDENCY PROPERTIES ?

 

WPF INTERVIEW QUESTIONS WITH ANSWERS: – WHAT ARE WPF CONVERTERS?

 

WPF INTERVIEW QUESTIONS ON EVENTS (TUNNELING, BUBBLING AND DIRECT)

 

What are the advantages of using WPF ( WPF interview questions with answers)?

 

Explain WPF bindings?( .Net WPF Binding interview questions)

 

WPF Interview questions with answers :-What is XAML in WPF and why do we need it?

 

What are the different kinds of controls in WPF?(C# WPF Interview questions with answers)

 

Can you explain the complete WPF object hierarchy?(WPF Interview questions with answers)

How does “UpdateSourceTrigger” affect bindings?( C# WPF interview questions with answers)

WPF Interview questions :- Which are the different namespaces and classes in WPF ?

What are resources in WPF? (C# WPF Interview questions with answers)

Explain multi binding and multivalue converters? (.NET WPF  Interview questions with answers)

Explain the difference between static and dynamicresource? (.NET WPF interview questions)

18 important WPF interview questions asked in WPF interviews.

.NET WPF(Windows Presentation Foundation) interview questions: - What is WPF? What are the advantages of WPF over Winforms?

Explain WPF relative binding / relative resource? (.NET WPF Interview questions with answers)

Explain Ancestor relative source binding in WPF ? ( WPF Interview questions with answers)

Explain the need of binding and commands?(WPF Interview questions)

Can you explain WPF command with an example? ( WPF Interview questions with answers)

Explain the need of “INotifyPropertyChanged” interface? ( C# WPF Interview questions with answers)

What is MVVM? (WPF MVVM Interview questions)

What is the importance of command and bindings in MVVM pattern? ( WPF MVVM Interview questions)

What is the difference between MVVM and 3 layer architecture? ( WPF  MVVM Interview questions with answers)

Explain delegate command? (WPF MVVM interview questions)

WPF Interview questions with answers

Explain WPF styles?(C# WPF Interview questions with answers)

Explain Multitrigger concept in WPF?( C# WPF Interview questions with answers)

How are WPF observable collections different from simple .NET collections? (.NET WPF Interview questions)

What is the difference between control templates and data templates? ( .NET WPF Interview questions)

What are various ways of doing alignment in WPF?( WPF Interview questions with answers)

 

Algorithm Interview Questions


Algorithm interview questions and answers: – Can you write code for bubble sort algorithm?

Algorithm interview questions and answers: – What is inserted sort algorithm?

SQL INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

SQL Server Interview Questions & Answers Article

SQL Server interview questions and answers: - What is HID data type in SQL Server ?

SQL Server interview questions with answers: – How to get the top record without using max, top and order by keyword?

SQL Server interview questions with answers :- If you wish to store financial values which SQL Server data type is more suitable ?

SQL Server interview questions and answers: – What is the difference between Candidate Key, Primary Key, and Alternate Key

SQL Server interview questions with answers :- What are Indexes in Sql Server?

How to sort interactively using SSRS? (SQL Server reporting services interview questions)

How to do conditional formatting in SSRS? (SQL Server reporting services interview questions with answers)

WHAT IS NORMALIZATION AND EXPLAIN 1NF 2NF AND 3NF IN SIMPLE WORDS? SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

 

When you will use inner join and when you will use outer join? SQL Server interview questions with answers

 

Do you know anything about Temporary procedures in SQL?( SQL Server interview questions with answers)

 

4 SQL Server interview questions with answers on TempTb

 

Are full outer join and Cross join are same? ( SQL Server interview questions with answers)

 

Delete duplicate records: - SQL Server interview questions with answers

 

4 most asked  SQL queries during SQL Serverinterview’s

 

How Temporary tables are different from normal tables and what are its types ?( SQL Server interview questions with answers)

 

SQL Server interview Questions on JOIN’s

 

SQL Server interview questions: - How can you increase SQL performance?

 

SQL Server interview questions: - What problem you face if locking is not implemented?

 

Can we insert NULL’s in to UNIQUE key ? ( SQL Server  interview questions with answers)

 

Explain Normalization?(SQL Server Interview questions with answers)

Temp variablesVS Temp tables(SQL Server interview questions)

 


 




.NET INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

.NET interview questions and answers: - How to reverse a string in .NET ( DotNet)?

.NET interview questions and answers: - What is the use of Click Once?

.NET interview questions and answers: - Will the below codes create new instances?

C# and .NET interview questions with answers – What is Nuget?

Dependency injection (DI) VS Inversion of Control (IOC)

.NET interview questions with answers: - What is the difference between Reflection and Dynamic?

Five Great .NET Framework 4.5 Features

ASP.NET MVC 4 interview questions with answers: - What is the use of “AllowHTML” and “ValidateInput” attributes?

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

.NET interview questions with answers: – Can we use events without delegates ?

.Net Interview question Edition 6 is available now.

.NET interview questions with answers: – What’s the difference between catch with parameter and catch without parameter?

.NET interview questions : - What is the use and difference between “IS” and “AS” keyword?

.NET interview questions with answers: - Build solution VS Rebuild solution VS Clean solution

HTML 5 interview questions with answers for LocalStorage and SessionStorage

.NET 4.0 interview questions with answers: – What are code contracts?

What are portable class libraries? ( .NET interview questions with answers)

How to loop through ENUM using C# (.NET interview questions with answers)?

What are transactions in C#? (.NET interview questions with answers)

What are ACID Properties( .NET Interview questions with answers)?

.NET interview questions: – What are the areas that need to be concentrated for senior(9+ years experience)persons in .NET technologies?

.NET interview questions: - Explain real time scenarios in Factory Pattern, Abstract Pattern, Singleton, WCF and REST services

What is the difference between IS A and Can a Relationship?( .NET Interview questions with answers)

What is the use of ENUM Flags(.NET Enum Interview question 2)?

What is the difference between .Net,C#, Asp.net, Asp.net Web Forms and Asp.net MVC and MVC?( C# and ASP.NET Interview questions)

ADO.NET interview questions: - Explain in detail the fundamental of connection pooling?

.NET interview questions: – Can you explain generics in .NET?

What are Properties and methods ? ( .NET OOP Interview questions with answers)

What’s the first step you take for implementing any of Design Pattern?( .NET  Design pattern interview questions with answers)

.NET interview questions: - What are different types of JIT?

ADO.NET Interview Question: - What are the major differences between classic ADO and ADO.NET?

.NET interview questions: – What is the difference between Reflection and Dynamic?

What is the Use of interfaces?( .NET Interview questions with answers)

.NET interview questions: - What role did you play in your project and company?

Visual studio 2012 Fakes

.NET interview questions: - So how can we clean unmanaged objects and also maintain performance?

ADO.NET Interview Questions: - What are basic methods of Data adapter?

.NET interview questions: - What are system level exceptions and application level exceptions?

.NET interview questions: - What is UML and which are the important diagrams?

.NET interview questions: - What is time out support in regex (regular expression)?

.NET interview questions: - How can we improve performance of .NET?

.NET interview questions: - Can you explain the concept of “Short Circuiting”?

.NET interview questions: - Can you explain Forms authentication in detail?

What is the difference between VAR and Dynamic keyword? ( .NET Interview questions with answers)

.NET interview questions: - What are similarities and difference between Class and structure?

Can you compare String.IsNullOrEmpty vs String.IsNullOrWhiteSpace ? ( .Net Interview questions with answers)

.NET interview questions: - Distinguish between Reflection and Dynamic?

.NET interview questions: - In which scenarios we can use serialization and when to use what binary serialization or XML serialization?

.NET interview questions: - Are there any readymade objects in .NET by which we can implement Lazy loading?

.NET interview questions: - What are different access modifiers?

ADO.NET interview questions: - Explain in detail the fundamental of connection pooling how to enable and disable connection pooling?

ADO.NET interview questions: - What is the namespace in which .NET has the data functionality class?

ADO.NET interview questions: - What are the different components in ADO.NET?

ADO.NET interview questions: - Show difference between “Optimistic” and “Pessimistic” locking and how many ways are there to implement optimistic locking in ADO.NET?

.NET interview questions: - Does code contract only do dynamic checks?

ADO.NET interview questions: - How can we fire a simple SQL Statement using ADO.NET?

.NET interview questions: - What basic steps are needed to display a simple report in crystal?

ADO.NET interview questions: - What are basic methods of Data adapter and mention the use of data adapter?

.NET interview questions: - What is UML? How many types of diagrams are there in UML?

.Net Interview Questions - What is MVC, MVP and MVVM pattern?

.NET interview questions: - How can you define a property read only for external world and writable in the same assembly?

Explain the implicit and explicit conversion of data types with examples?( .NET interview questions on data type)

.NET interview questions: - What is Reflection its implementation and practical uses?

What is downcasting and upcasting? (.NET interview questions with answers)

.NET interview questions: - How to decide on the design consideration to take a Data grid, data list or repeater?

.NET interview questions: - If we want to update interface with new methods, what is the best practice?

.NET interview questions: - How does selection sort algorithm works?

XML(.NET) interview questions: - What is XML?

.NET Interview questions: - If a validation is very complex what will you do?

.NET interview questions: - How can we stop the class from further inheriting?

XML (.NET) Interview questions :- Explain simple Walk through of XmlReader.

.NET interview questions : - How can we improve performance of .NET and show the difference between .NET 1.X, 2.0, 3.0, 3.5 and 4.0?

How to convert string to ENUM value ?( .NET interview questions with answers)

.NET architecture interview questions series: - What is mean by modeling language?

.NET architecture interview questions : - What are benefits and Limitation of using Viewstate, hidden frames and Cookies?

.NET interview questions: - What is GAC (Global Assembly Cache)?

.NET interview questions: - Explain Nuget?

.NET Testing interview questions: - What is the difference between Unit testing, Assembly testing and Regression testing?


.NET interview questions: - What is Code Access Security (CAS) and how does it work? Is CAS supported in .NET 4.0?


.NET interview questions: - What are the advantages /disadvantages of lazy loading?


.NET interview questions: - What is the use of DEBUG directive?


.NET testing interview questions: - What is Mock testing and how to implement it?


.NET interview questions: - What is the difference between DEBUG and Release?


.NET testing interview questions: - How can we UNIT test private methods using VSTS? Is it good to practice to UNIT test Private methods?


Explain 3 layer architecture ( .NET Interview questions)?


.NET interview questions : - What is a delegate and how can we create a delegate? What is a multicast delegate?


ADO.NET interview questions: - How to add/remove row is in “Data Table” object of “Dataset”? How to load multiple tables in a Dataset & adding relation between tables in a Dataset?


What is the difference between Array, ArrayList and List?( .Net Interview questions)

.NET interview questions: - How to implement DTC in .NET?
.NET interview questions: - What is an Interface and what are abstract classes

.NET interview questions: - Interface vs. abstract class

.NET interview questions: - How to implement practically Lazy loading in .NET?


.NET interview questions: - How can we handle exceptions in .NET? What if we do not catch the exception?

.NET interview questions based on Projects.


.NET interview questions: - What is shadowing? What is the difference between Shadowing and Overriding?

.NET interview questions: - All about Design Patterns in .NET


.NET interview questions: - How can we improve performance of .NET/ASP.NET/SQL Server?

.NET interview questions: - What benefits does sealed keyword provide?


.NET Architecture UML interview question


.NET interview questions: - How to maintain performance and can clean unmanaged objects?


.NET interview questions: - Explain ENUM and its benefits? What is the use of Flagsin ENUM?

.NET interview questions: - How to create a windows service using .NET?

.NET interview questions: - Explain in details about Indexer and can we have static indexer in C#?

.NET interview questions: - What is the difference between arraylist and list? Are Arraylist faster or Arrays?

.NET interview questions: - What is Native Image Generator (Ngen.exe)? Does NGEN.EXE always improve performance?

.NET OOPS interview questions: - What is OOP? What are different properties provided by Object-oriented systems?

.NET OOPS interview questions: - How abstract with only abstract method is it different from interfaces? Also mention best practice to update interface with new methods?

.NET interview questions: - What is the difference between delegate and events? Can we have return type, access modifiers and shared events?

.NET interview questions: - What is Manifest? Where is the version information stored of an assembly? Is versioning applicable to private assemblies?

.NET Generics interview questions: - Explain Generics and concept of Generic Collection in .NET?

How to learn .NET: - In parent-child relationship which constructor will fire first and in which instances you will declare a constructor private?

Basics of .NET and learning tutorials on CTS and CLS


Online resource to learn .NET on Reflection and Dynamic

Online guide to learn .NET for Object initializer in C#?

QuestPond for Freshers on IL code, JIT, CLR, CTS, CLS and CAS

QuestPond: Interview Questions and Answers on AJAX and how does it help?



ASP.NET Interview Questions & Answers Article










MVC Interview Questions And Answers Article

 

(MODEL VIEW CONTROLLER)MVC INTERVIEW QUESTIONS AND ANSWERS

 

MVC INTERVIEW QUESTIONS WITH ANSWERS VIDEO: – WHAT IS WEB API HOW TO IMPLEMENT THE SAME?

 

ASP.NET MVC  4 INTERVIEW QUESTIONS WITH ANSWERS: - WHAT IS BUNDLING AND MINIFICATION IN MODEL VIEW CONTROLLER ?

 

MVC INTERVIEW QUESTIONS WITH ANSWERS :- IS IT POSSIBLE TO RETURN VALUES INSTEAD OF ACTIONRESULTS?

 

MVC INTERVIEW QUESTIONS WITH ANSWERS :- WHAT ARE THE ACTIONRESULTS AVAILABLE IN MVC?

 

MVC INTERVIEW QUESTIONS WITH ANSWERS:-HTML.PARTIALVSHTML.RENDERPARTIALVSHTML.RENDERPAGE IN MVC

MVC VS ASP.NET ( MVC INTERVIEW QUESTION WITH ANSWERS )?

 

HOW CAN WE DETECT THAT A MVC CONTROLLER IS CALLED BY POST OR GET ? ( ASP.NET MVC INTERVIEW QUESTIONS WITH ANSWERS)

 

WHAT ARE THE DIFFERENT WAYS BY WHICH YOU WILL GET FORM DATA IN CONTROLLER? ( MVC INTERVIEW QUESTIONS WITH ANSWERS)

 

WHAT IS THE DIFFERENCE BETWEEN PRESENTER AND CONTROLLER IN MVC?(MVC INTERVIEW QUESTIONS WITH ANSWERS)

 

LEARN MVC (MODEL VIEW CONTROLLER) STEP BY STEP IN 7 DAYS – DAY 4

 

MVC Interview questions and answers PDF

 

MVC interview questions with answers

 

ActionResult vs. View() vs. ViewResult :- MVC interview questions with answers

Explain Areas in MVC?( MVC interview questions with answers)

 

Can you explain the purpose of ViewModel in MVC?( ASP.NET MVC Interview questions with answers)

ASP.NET MVC interview questions: - What are Filters in MVC?

What are areas in MVC?( MVC Interview questions with answers)

Explain the concept of View Model in MVC? 

Exception Handling in MVC

Explain MVC application life cycle?

100 MVC Interview question PDF download released , Enjoy

How can we use two (multiple) models with a single view?(MVC Interview questions)

MVC HTML.Form vs Ajax.Form – MVC interview questions with answers

Learn Microsoft Business intelligence step by step – Day 1

Can you create TempBag just like ViewBag?( MVC Interview questions)

MVC Unit Testing Unleashed

MVC and .NET learning tutorials for components of MVC and how do you perform unit testing in MVC?

Explain MVC model binders ? ( ASP.NET MVC interview questions)

Explain the difference between layout and master pages ? (MVC Razor interview questions) 


ENTITY FRAMEWORK INTERVIEW QUESTIONS ARTICLE


Windows Workflow Foundation(WWF) interview questions with answers Article

XML Interview Questions With Answers Article


Explain XML,DTD and XSL?(XML interview questions with answers)

HTML 5 Interview questions With Answers Article

HTML 5 interview questions with answers for LocalStorage and SessionStorage

 

How is the page structure of HTML 5 different from HTML 4?( HTML 5 Interview questions with answers)

 

What is datalist in HTML 5 ( ASP.NET HTML interview questions)?

 

What are the different new form element types in HTML 5?( ASP.NET HTML 5 interview questions with answers)

 

What is output element in HTML 5?( ASP.NET HTML 5 interview questions)

 

What is the difference between Canvas and SVG graphics?(ASP.NET HTML 5 interview questions with answers)

 

ASP.NET HTML 5 interview questions on SVG and Canvas

ASP.NET HTML5 interview questions with answers

What are web workers and why do we need them ?( ASP.NET HTML interview questions with answers)

 

Why do we need HTML 5 server-sent events? (ASP.NET HTML interview questions)

How can we add and remove data from local storage?(ASP.NET HTML 5 interview questions)

What is local storage concept in HTML 5? ( ASP.NET HTML 5 interview questions)

What is the difference between local storage and cookies? ( ASP.NET HTML 5 interview questions)

What is WebSQL?( ASP.Net HTML 5 interview questions)

 

What is session storage and how can you create one?( ASP.Net HTML 5 interview questions with answers)

 

What is application cache in HTML5?( ASP.NET HTML 5 interview questions with answers)

ASP.NET HTML 5 Application cache interview questions with answers

 

Explain the term cascading in style sheet ? ( CSS Interview questions)

What is difference between DIV vs SPAN in HTML ?( ASP.Net Interview questions)

HTML 5 Canvas Interview questions: - Canvas in HTML 5.

QuestPond’s interview questions and answers on HTML 5

 

Learn HTML 5 in 3 days – Day 1

 

 

 

Dotnetspider Questions And Answers Article

 

 

What is downcasting and upcasting ? ( .NET interview questions with videos)

 

What is the difference between String vs string? ( C# interview questions) ?

 

 

JAVASCRIPT INTERVIEW QUESTIONS WITH ANSWERS ARTICLE

 


3 IMPORTANT JAVASCRIPT IMPORTANT INTERVIEW QUESTION WITH ANSWERS