Home Forums Data Warehousing Integration Services How to avoid technically the null values while concatenating columns RE: How to avoid technically the null values while concatenating columns

  • Your message is a little confusing: are you importing or (I think) exporting?

    What do you mean when you say that your file layout "becomes a mess"? Can you provide some sample data highlighting the problem?

    Instead of 'passing spaces', what's wrong with an empty string?