Tag Archives: Error

Frequently used MSSQL Commands


Posted in commands, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment

SSIS Error, Solution: This error is thrown by Connections collection when the specific connection element is not found

Typically SSIS will throw this error if a connection used by SSIS package is either deleted or renamed. Most of the time it will be a human error, when we copy SSIS package and modify the package, renaming and deleting … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , | Leave a comment

SSIS Error and resolution: 0x80004005, Invalid character value for cast specification

In one of the SSIS packages while reads data from FlatFile and pushes into SQL, I received a strange error Invalid character value for cast specification. The solution is tricky, I had to change RetainNulls Property to True at FlatFile … Continue reading

Posted in SQL Error, SQL Server, SSIS | Tagged , , , , , | Leave a comment

Fix SSIS Error while execution: System.IO.IOException: The process cannot access the file ‘PATH\Project.ispac’ because it is being used by another process.

Typically this error occurs when Visual Studio crashes while a package is running in debug mode! .ispac file will be locked by the debug process and does not allow you to execute SSIS package in Visaul Studio (in debug mode). … Continue reading

Posted in SQL Server, SSIS, Visual Studio | Tagged , , , , | 8 Comments

The external metadata column collection is out of synchronization with the data source columns.

One of my SQL Job failed with Error and the failure was due to an issue with SSIS Package. There are multiple reasons when this error occurs but I just share the approach and one of the examples: Do you … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , | Leave a comment

A required privilege is not held by the client. The step failed. – SQL Job Fails with error – Solution

I was aware of the best practice to use SQL Server Configuration Manager instead of using MMC Console but faced this error for not following the best practice. Well, I had to change the Logon account of my SQL Server … Continue reading

Posted in SQL, SQL Error, Windows Server | Tagged , , , | Leave a comment