ssis - SQL does not read more than 65536 characters from a text column -

I have a text field in the table with other spatial types. As part of an SSIS package, I have the same table I'm using this text area to run updates (as a SQL function) and updating geometry and geography columns. I was able to successfully run the following query yesterday

  Location Location [Physics] = Geometry Update: STGeomFromText (shape text, 4326). Location is not a MacIeal () location where size text is   
 However, today it is throwing the following exception:  
 
 Message 6522, level 16, state 1 , Line 10. During a user's execution a .NET Framework error occurred defined routine or total "geometry": System.FormatException: 24141: the status of the input is expected a number at 65536.   
 When I saw the size, it is definitely a legitimate size, hence the problem is not in the shape, but SQL is reading only 65536 characters from the column. And it works when the size sheet is less than 65536 characters.  
 It would be great if someone helped me out of this and how to teach me more than 65536 characters from a text field.   
 
 
 So, finally I got the problem and the solution for it. Although the problem is quite discrete, I hope it helps someone else.  
 Problem: I started searching for this 65536 character error message and prompted me to blogs that mention SQL memory problems. I then checked my SQL log and reported the error message with it:  
 
 Failed to reserve memory near the size = 65536   
 The illusion was that it worked one day and then the next day, it started throwing me an error message, so I definitely had a memory food operation somewhere. Carefully examined, I came to know that there was a derivative column on my SSIS package which was the root cause of all memory issues.  
 Solution: I removed the derivative column operation and transferred it instead of a SQL function and its beauty was once working, so the derived column was checking the length of a text field And it was setting it to zero. again.