Post reply

Problem With .txt file in SSIS

  • April 1, 2008 at 8:27 am

    #184667

    hi, all

    i have a txt file - and i am trying to load data into sql destination table

    text qualifier= none

    header row delimeter = CR-LF

    column delimeter = |

    row delimeter = CR-LF

    I get these error when i am trying to make my connections. on the column tab the columns are mismatched. However in DTS the same file works fine with same configurations---

    TITLE: Microsoft Visual Studio

    ------------------------------

    The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly.

    ------------------------------

    Here is little sample from file

    01|2341390|03/30/2008|ajmeayworga@comcast.net|Y|SFX2DP||0

    05|98741H

    01|2341458|03/30/2008|BJM023655@aol.com|Y|SFX3DP||0

    05|LCS4800

    05|HOL4900

    01|2341478|03/30/2008|iarunanplegs@yahoo.com|N|SFX3DP||0

    02|TKAHM10001

    03|$40 Unlimited Text Talk and Unlimited Picture Talk

    01|2341485|03/30/2008|hervbwedissg@earthlink.net|N|SFX3DP||0

    02|CDM1450M

    ANY HELP WILL BE HIGHLY APPRECIATDE!!!!!!!!!!! THANKS

  • April 1, 2008 at 8:38 am

    #796540

    gyanendra.khadka (4/1/2008)

    hi, all

    i have a txt file -

    text qualifier= none

    Hello,

    The information provided is not sufficient. You need to tell us what you are trying to do and what sort of error(s) encountered. If there is not much information you provide for someone to look into it then how can you expect a solution.

    Thanks


    Lucky

  • April 1, 2008 at 8:40 am

    #796543

    sorry, on first i mistakley press the button. u can goahead and see the details here now, since i have edited the postings, Thnaks

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

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