By continuing your visit to this site, you accept the use of cookies. They ensure the proper functioning of our services and display relevant ads. Learn more about cookies and act

Not yet registered? Create a OverBlog!

Create my blog

Shivprasad koirala

Shivprasad koirala

Interview questions for .NET,VB.NET,SQL Server,C#,Design pattern,Sharepoint,WCF,WPF,WWF,Silver light,reporting services,java,tester,software testing

Blogs

questpond.over-blog.com's name

questpond.over-blog.com's name

Interview questions for .NET,VB.NET,SQL Server,C#,Design pattern,Sharepoint,WCF,WPF,WWF,Silver light,reporting services,java,tester,software testing
Shivprasad koirala Shivprasad koirala
Articles : 459
Since : 26/10/2010
Category : Tech & Science

Articles to discover

Short-key error in SSIS project.

Short-key error in SSIS project.

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 Fil
Working with Script Component in SSIS.

Working with Script Component in SSIS.

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 whic
CDC(Change Data Capture) using SSIS.

CDC(Change Data Capture) using SSIS.

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 Inser
How to remove duplicate value while working with Pivot component?

How to remove duplicate value while working with Pivot component?

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 “A
Create a Job in SQL Server agent to run our XMLA query.

Create a Job in SQL Server agent to run our XMLA query.

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
SQL Server Agent(For beginners)

SQL Server Agent(For beginners)

SQL Server Agent helps by ensuring to run scheduled job on specified time by the user and internally it uses SQL Server to store job information. Job scheduling involves task running daily, weekly or monthly on a fixed or specific time. It is the feature of SQL Server and involves we have series of step to activate it if you find below error messag
Partitions in SSAS

Partitions in SSAS

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
Primary key error while using SCD component.

Primary key error while using SCD component.

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
Working with “Foreach Loop container” with “Execute SQL Task”

Working with “Foreach Loop container” with “Execute SQL Task”

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
“For Loop” container in SSIS

“For Loop” container in SSIS

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 f