Category Archives: SSIS

COZYROC to connect Salesforce from SSIS

http://www.cozyroc.com/ provides SSIS Library to interact with multiple 3rd party services including Salesforce. I have implemented POC to pull data from Salesforce using COZYROC Connector! Here are the step by step information to pull data from Salesforce Object… • Installation: … Continue reading

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

SSIS – MERGE JOIN with OR condition

Do you know if there is any option to implement OR condition with Merge Join in SSIS? NO, there is no such option (Let me know if there is a way and I am not aware of it)! Recently I … Continue reading

Posted in knowledge, Productivity, SQL Query, SQL Server, SSIS | Tagged , , | Leave a 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

Manually adding new column into Flat File Connection Manager and column order

Flat File connection Manager can be manually modified to add a new column or remove existing columns, there is no need to Rest Columns which removes the customization done on existing columns. Be careful and make sure to insert new … Continue reading

Posted in SQL Server, 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 , , , , | 5 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