Home Forums SQL Server 2005 SQL Server 2005 Integration Services no matter how large the destination column eg. nvarchar(max), excel source choke on column RE: no matter how large the destination column eg. nvarchar(max), excel source choke on column

  • May 16, 2013 at 1:36 pm

    #1615985

    shop air compressor - Speedaire State of Washington pressure vessel ID = 33501-03W

    looks like browser is converting the characters in my excel from HTML to human readable code. No matter what I do, I can't show you exactly what's in my excel source, but it's not pretty. It's html gobbelty goop

    the asset description is actually populated with a bunch of hash marks, ampersands, and semi colons, all of which disappear into nice html when I click save.....