Posted in Data Migration, SSIS

SSIS – Error in Script Component

May God bless you with JOY, PEACE and LOVE on this Christmas

Wish you all Merry Christmas

Friends,

I am so happy to connect with you all through blogging. In this Christmas time, I would like to share my work experience on the recent data migration project.

Core logic required was

Replacing comma separated GUID values in the column with the corresponding name for the GUID from the system

I should not use tables need to manipulate using flat files.

I did it as two-step:

  1. Split the values, frame it like a table, do the join with reference table to get the name of the GUID and store it in a flat file.
  2. Then convert into comma separated values as source.

Just like this below figure

Untitled

for second step, i got a snippet from google search. It really reduced my development time for this work. Here is the link

Prototype is ready. While implementing the similar transformation, I just copied the data flow task and done the required changes.

While executing the whole package, faced two error (where the DFT-Data Flow Task pasted)

Error 1:

The value is too large to fit in the column data area of the buffer

Normally, this error comes if the source column length is greater than the destination column. I am sure in my project maintained the same.

I don’t have any clue, what’s wrong? Refreshed the component, multiple time build the script component project. No use..

Finally got the solution..Delete the script component and Create it 😀

Lesson learnt: DON’T COPY PASTE THE SCRIPT COMPONENT. Time wasting on development is better than debugging the error

Error 2:

The code in the above link will not handle empty rows. So I got error like this.

There is no current row in the buffer. A row may need to be added using the AddRow method.

Added code for validate the empty rows. Problem resolved.

That’s all from my end.

If you have any suggestions on this topic, please do share your thoughts.

Feel free to reach out to me If you need any help on data migration project / consulting.

Expertise in SSIS, Talend (ETL tool), Dynamics 365/CRM adapters – Kingswaysoft, Cozyroc, Scribe, OneTapAdapter.

Posted in Data Migration, SSIS

SSIS – Binary code for the script is not found

Last Friday, I was into an issue. My package is working fine in development server. but its not working in the deployed server.

untitled1

 

untitled

 

Constantly getting the same error. Even after the multiple Build/Rebuild/Clean on the Script component and Project 🙁

Finally Spark came up.. whether the Script Component project build is giving new build file every time or giving the pre-compiled version of it.???

Yes you got it.. I too thought the same…

index

Then how to clear the cache in Script component ?

Easiest way is that make some changes in code, Build it. ITS WORKED FOR ME. Hope will for you too.

Share with me, if you got some other way to do..

Happy blogging !!!