Monthly Archives: July 2011

How to Get the Primary Key and foreign Key between two tables

Posted on July 28, 2011 by randheerparmar

These are the few tables which can be used to check the foreign key and primary key column in a table. It will give both columns from both tables. INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA.TABLE_CONSTRAINTS INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Posted in SQL Server Interview Questions and Answers | 1 Comment

Download SSRS Interview Questions and Answers PDF

Posted on July 27, 2011 by randheerparmar

SSRS Interview Questions and Answers PDF Download SSRS Interview Questions and Answers Download PDF doccuments I am providing the links for downloading the SSRS interview questions list. These are the few general questions. You can download and read these sql server … Continue reading →

Posted in Downloads | 4 Comments

Reading Data from XML Source Adapter

Posted on July 27, 2011 by randheerparmar

Reading Data from XML Source Adapter XML source adapter does not support mixed content model on complex types. I was getting the above error while try to read my XML file from XML source adapter in data flow task. I … Continue reading →

Posted in SSIS Issues and Resolution | 1 Comment

SQL Server Interview Questions and Answers : Case Study 1

Posted on July 25, 2011 by randheerparmar

Company Asked : This question was asked in RBS India Technical round. There is the retail store with different products. A costumer can place multiple orders and one order one order can contain multiple products. Product comes through a supplier. For this … Continue reading →

Posted in SQL Server Interview Questions and Answers | Leave a comment

Issue while reading data from XML in SSIS data flow task

Posted on July 22, 2011 by randheerparmar

Issue while reading data from XML Error Message [XML Source [1]] Error: The “component “XML Source” (1)” failed because truncation occurred, and the truncation row disposition on “output column “Query” (7382)” specifies failure on truncation. A truncation error occurred on … Continue reading →

Posted in SSIS Issues and Resolution | Leave a comment

ISNULL function not working in SSIS as it works in TSQL

Posted on July 21, 2011 by randheerparmar

ISNULL function not working in SSIS as it works in TSQL: ISNULL Function in TSQL replaces the null value with other value. For Example ISNULL (@value, ‘Name”) in this if there will be null value in @value it will be … Continue reading →

Posted in Uncategorized | 3 Comments

Issue in reading object variable in Script Task in for loop in SSIS

Posted on July 19, 2011 by randheerparmar

Issue in reading object variable in Script Task in for loop in SSIS. While working with SSIS object variable I have faced some issue when I used it in loop and not able to get any proper solution on web. … Continue reading →