Tag Archives: RetainNulls

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