Ramoji Ryali's Fundas

The interesting things I experimented with SQl Server.

Could not load package because of error 0xC0011002. Failed to open package file due to error 0x80070005 "Access is denied."

Came across this error while executing a SSIS package through a SQL Agent Job on a SQL Server 2008...

Author: Ramoji Date: 01/06/2011

Comparing data between two tables in SQL Server

As a database developer sometime or the other you might have come across this requirement and it can...

Author: Ramoji Date: 07/01/2010

Message "TFS10139: The following check-in policies have not been satisfied" comes in VSTS2010

Got this message after the upgrade from VSTS 2008 to VSTS 2010 while checking in a file. The message...

Author: Ramoji Date: 06/14/2010

Error while enabling CDC on a table. The server principal "xyz" is not able to access the database "msdb" under the current security context.

We came across the following error after successfully enabling CDC on a Database and then trying to...

Author: Ramoji Date: 05/12/2010

SSIS Data Flow Task fails with Unspecified Error

We have few SQL Agent jobs on SQL Server 2008 (10.0.2531) and these jobs are executing SSIS...

Author: Ramoji Date: 01/05/2010

SSIS package fails with Protocol error in TDS stream

Encountered this error while running a SSIS package through a SQL Agent Job on SQL Server 2008. The...

Author: Ramoji Date: 12/30/2009

Could not update the metadata that indicates database is enabled for Change Data Capture. The failure occurred when executing the command SetCDCTracked(Value = 1)

This error message comes when you are trying to enable CDC on a SQL Server 2008 database for which...

Author: Ramoji Date: 11/19/2009

Explicit value must be specified for identity column in table [XXXXXX] either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column

I encountered this error when explicitly inserting values in an Identity column of a Table that is...

Author: Ramoji Date: 11/13/2009

Failed to open package file due to error 0x80070020. The process cannot access the file because it is being used by another process. This happens when loading a package and the file cannot be opened or loaded correctly into the XML document.

This error message comes while performing one (Or both) of the following actions. 1. Run SSIS...

Author: Ramoji Date: 08/28/2009

Checkin cannot proceed because the policy requirements have not been satisfied.

I got this message while checking-in a file after the fresh installation of Visual Studio 2008...

Author: Ramoji Date: 08/26/2009

Transfer permissions between objects in SQL Server 2008

Sometimes we have to transfer the permissions from one object to another. Here the object could be a...

Author: Ramoji Date: 07/02/2009

The AcquireConnection method call to the connection manager failed with error code 0xC0202009

Sometimes the actual error lies somewhere and the error message directs us to look at something...

Author: Ramoji Date: 03/10/2009

General Network error. Check your network documentation.

This is a proper netwrok error and has nothing to do with the coding if any of your...

Author: Ramoji Date: 12/24/2008

Package migration from version 3 to version 2 failed with error 0xC001700A. The version number in the package is not valid. The version number cannot be greater than current version number.

I guess at least once every SQL developer might have come across this error on SQL Server 2008 while...

Author: Ramoji Date: 12/24/2008

How to open DTS packages in SQL Server 2008?

An error occurs if you try to open a DTS package from Leagcy --> Data Transformation Services in...

Author: Ramoji Date: 10/16/2008

Reading DTS and SSIS packages programmatically

Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in...

Author: Ramoji Date: 09/29/2008

Moving indexes from one filegroup to another in SQL Server

This is a pretty simple task but I would like to provide a generic method for doing this. It will...

Author: Ramoji Date: 09/26/2008

Creating new tables and loading data in SQL server by reading an Xml file

This kind of requirement may come if VSTS is used for test automation and the test results have to...

Author: Ramoji Date: 09/18/2008

How to get missing values from an Identity column?

Let us assume that there is an Employee table with EmployeeId as the Identity column in which some...

Author: Ramoji Date: 09/17/2008