Post reply

¬ text qualifier issue

  • February 18, 2011 at 1:53 am

    #144726

    I am using the ¬ character as a text qualifier in a connection manager for a comma delimited file:

    The data looks fine when I use the connection manager preview window:

    However at execution time, if I use a data viewer I can see that the connection manager is not using the text qualifier:

    The data injected into my OLE DB destination includes the text qualifier ¬.

    Can anybody suggest why this is happening? If not, can you suggest other infrequently used characters that will actually be recognised and used by SSIS at execution time instead of ignored like the ¬ character?

  • February 18, 2011 at 3:52 am

    #1288727

    Upon further investigation I was able to use the text qualifier { to successfully import the data. I don't know why the { character works but ¬ does not.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply