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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 09/17/2008