Hello anonymous user,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is to rid of the error , please do let us know if its not accurate.
Looking at the mapping data flow above , it seems like that you are reading some files and then on the sink side you are inserting them to dedicated sql . The error which you shared means that the column to which you are inserting the data has got a column width wich is less then the data which is coming in . Well had it been copy activity you could have used the fault tolenace option to over this . I think you should focus on the varchar columns and see if you can either increase column width ( eg varchar(100) to varchar(150) ) or in the derived column activity use the substring function to reduce the data size .
Please do let me if you have any queries.
Thanks
Himanshu
- Please don't forget to click on
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators