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.


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 table or view. We can write  a straight forward script using GRANT and REVOKE statements if this requirement is for one or two objects. But what if more number of objects are involved and the permissions that…


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 else. We end up wasting time in this process as the error message diverted us. Recently, we came across one such kind of scenario while calling a SSIS package in one of the Job steps on SQL Server 2008. The details are…