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 20, 2013 at 6:53 am

    #1643049

    Donny Z (8/19/2013)

    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.

    Take a look at: http://technet.microsoft.com/en-us/library/ms176114(v=sql.105).aspx

    A simple search brought that back. :rolleyes:

    HTH,

    Rob