Trim Functions in SSIS

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

1 Response

  1. RAKESH says:

    Use the below Expression in Derived Transformation it will work
    you can use any LTRIM, RTRIM or TRIM
    if your Source and Destination data type are CHAR, VARCHAR, NVARCHAR

    (DT_STR,50,1252)TRIM(sname)

Leave a Reply