THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Use Biml to Remove Spaces from Flat File Column Names

This blog has moved! You can find this content at the following new location:

Published Wednesday, July 6, 2016 1:19 PM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Thomas Meltofte Eriksen said:

If you are using Mist, how about just executing a Transfomer:

<#@ target type="FlatFileColumn" mergemode="LocalMerge" #>

<Column Name="<#= TargetNode.Name.Replace(" ","") #>" />


July 7, 2016 5:51 AM

andyleonard said:

Hi Thomas,

  Yep, that'll also work - and it's just a couple lines of code!


July 7, 2016 7:41 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement