We can remove White Space in Source document using
REPLACE or TRIM Functions in Derived Column transformation before loading the data into SQL
On this page of the site you can watch the video online SSIS||How to handle spaces in source while loading data into SQL tables? with a duration of hours minute second in good quality, which was uploaded by the user LearnSQLtoSSIS 13 February 2024, share the link with friends and acquaintances, this video has already been watched 127 times on youtube and it was liked by 0 viewers. Enjoy your viewing!