Category Archives: SQL Error

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

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

Fix: DBAMP Error: MALFORMED_QUERY: Implementation restriction: CollaborationGroupRecord requires a filter by a single Id, CollaborationGroupId or RecordId using the equals operator

Actual problem is the procedure fails to pull CollaborationGroupRecord table data due to api restrictions. You need to exclude the table from sf_replicateAll and/or sf_RefreshAll procedures as a resolution. Fix: Add below 2 lines of code next to < if … Continue reading

Posted in Referene, SQL Error, Useful Link | Tagged , , , , , , , | Leave a comment

Fix – SSIS to Oracle connectivity issue during run time (Error code: 0x8007007E/0xC0202009)

SSIS package started failing when I execute the package though all validations are successful. The failure was related to oracle connection failure. Fix: I had to change the package to Execute in 32 bit to fix the connectivity failure. Change … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , , | 3 Comments

Database in Single User Mode – Resolution

When the database gets stuck in Single_User mode, try these options to bring it back to Multi_User mode! • T-SQL statement to change it to MULTI_USER • You will not able to complete above query if there is any active … Continue reading

Posted in knowledge, Script, SQL, SQL Error | Tagged , , , | Leave a comment

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