Home Forums Data Warehousing Integration Services Excel import - force column to be string (SSIS 2005) RE: Excel import - force column to be string (SSIS 2005)

  • August 19, 2013 at 9:47 pm

    #1642934

    Jeff Moden (10/16/2011)

    The way I solved this problem for my group was to simply use QUOTENAME(columnname, '"') and make sure that I used '"' as the text qualifier.

    Can anyone explain more about this??

    This kind of statement is like "I know how, but I won't tell." kinda statement.

    Best Regards.