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 server.The job is running under a windows security account and the SSIS package is stored on file system of the server. The exact error message received was as shown below. Executed as user: Domain\User. Microsoft (R)…


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 be achieved using many ways including built-in features like Checksum and TableDiff utility. However, I would like to share an alternate way to achieve the objective, which might be useful in some situations. Usually the intention of comparison is to find…


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 disappeared after installing “Team Foundation Server Power Tools April 2010” from the below location. Hope this helps 🙂  


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 enable CDC on a table in SQL Server 2008 SP1 (Version 10.0.2531.0) Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 607 Could not update the metadata that indicates table [dbo].[MyTable] is enabled for Change Data Capture. The failure occurred when…


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 packages, which are created using BIDS 2008. The jobs are scheduled to run daily at a low frequency. The intention is to run these jobs like a demon service. We started getting the “Unspecified Error” at random intervals of time and…


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 processing in the package is a pretty simple and the purpose is to export data from few tables from one SQL Server to another. Both the source and target servers are on SQL Server 2008 (10.0.2531) and Data Flow Task (with…


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 the owner is not “sa”. The exact error message will be as shown below. Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186 Could not update the metadata that indicates database [XXXXX] is enabled for Change…


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 created in a SQL Server 2008 Database and the DB is not part of any kind of Replication. I have made sure that “Identity_Insert” is turned on for that table before performing the insert. Also I have checked that “NOT…


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 Package using dtexec.exe (Either from a command file or through a Job running on SQL Server 2008) 2. Open SSIS package using VS2008 or BIDS If you have a log file for the job, the exact error essage you see would be as…


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 Professional and TFS client. This message disappeared after installing VSTS 2008 Power Tools. The download link is provided for your quick reference here. Please share your feedback if the same fix has helped you.