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 11:52 am

    #1615940

    for what it's worth, advanced editor for the excel source has the datatype property for this column set to Unicode string [DT_WSTR], 255. The destination is varchar(max).

    However, as I say, if this column is enabled, the package fails at source.