SQL Server Performance

text qualifier

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 16, 2007.

  1. fmardani New Member

    Hi,
    Using SSIS, I am importing the data of a text file into a sql server table.
    After the import, I Can not figure out why the texts inside the sql server have double quotes around them. This is similar to the data inside the text file. For example, the value "Simpsons" appears with the "" as you can see whereas I want it to appear without the "" inside the sql server table.
    In the connection manager, the file connection has a text qualifier of <None>

    Thanks
  2. satya Moderator

    http://www.microsoft.com/downloads/details.aspx?familyid=91e24d1d-acf0-45b1-a9a5-9ea1c7bd0463 see downloading this will help you.

    I believe you have asked about guided tour in SSIS before,http://sqlserver-qa.net/blogs/tools/archive/2007/05/04/ssis-control-flow-basics.aspx fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page