Category Archives: SSIS

COZYROC to connect Salesforce from SSIS

Posted on August 19, 2015 by vijred

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 , , , | 1 Comment

SSIS – MERGE JOIN with OR condition

Posted on June 10, 2015 by vijred

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

Posted on May 13, 2015 by vijred

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 , , , | 3 Comments

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

Posted on May 6, 2015 by vijred

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

Posted on April 29, 2015 by vijred

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.

Posted on April 22, 2015 by vijred

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 , , , , | 10 Comments

How to truncate text string in SSIS

Posted on April 15, 2015 by vijred

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

UPSERT in SSIS

Posted on March 11, 2015 by vijred

I had a work on a quick delivery which involves UPSET using SSIS, following is refresh! What is UPSERT in typical scenario? When I have to insert records into destination if the record does not exist and/or update multiple values … Continue reading →

Posted in Productivity, SQL, SSIS | Tagged , , , , | 1 Comment

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

Posted on February 18, 2015 by vijred

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

SSIS Expressions – Date operations, Data Type conversions and more…

Posted on January 14, 2015 by vijred

I had to use Derived Column Transformation Editor to split a datetime column into 2 parts one with Date only and another column only with Time. I had to invest some time to get the simple solution as follows… There … Continue reading →

Posted in Productivity, Referene, SQL, SSIS | Tagged , , , , , | 1 Comment