In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In fact, a good number of the commonly used functions from T-SQL are in SSIS as well. Here we will explore the different Trim functions found in SSIS. We will be using the test phrase " Test " to illustrate the three functions: LTRIM, RTRIM and TRIM. LTRIM (Left Trim): Just as in T-SQL, this removed empty spaces from the beginning (or left) of a string. Notice the highlighted result that the t...
Read More
In an SSIS package you have the option to choose from a wide range of source from Flat Files to writing queries using OLEDB sources such as SQL Server. Often times, such as writing queries against SQL Server, the metadata will come from the table and you won't need to worry about truncation in the source. Flat files are scanned and metadata is chosen based on the file so those are usually good to go as well. Excel however tends to just use the default length on all columns of 255 characters. Thi...