Post reply

SSIS, and SQL Server 2005 on Importing a Text File

  • July 28, 2008 at 12:37 am

    #124237

    I am puzzled why another character makes a difference in importing a text file into a table in SQL Server 2005.

    For example, data in the following line are not shown in a table in SQL Server 2005, which was created by SSIS Package, when an attempted was made to import a text file:

    ACE/DEFENSE - Aerospace/Defense Products & Services,06/27/2008

    However, if I import the line, without "A" in the line above, as shown below,

    CE/DEFENSE - Aerospace/Defense Products & Services,06/27/2008

    then, only part of the line is imported: Products & Services,06/27/2008.

    I appreciate any constructive comments on this puzzle.

  • July 28, 2008 at 3:24 am

    #849007

    Because you are having slash (/) in between of your text. That's why it's ignoring /Defence part. Just use "ACE/Defence ....... " then it will insert whole of your text

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

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