Monthly Archives: April 2015

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

How to truncate text string in SSIS

I was working on a solution to read table data from .csv file and push into a SQL table. I started receiving error when one of the Column text had 8000+ characters. I just need to push only 1000 characters … Continue reading

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