Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: one more import issue

    I am importing a text file with '~' column delimiter and my text has in the file has some format.If i import the data into the sql table all the text is appearing in one line by missing the formart.

    (here is the sample data.
    empid~empname~emp_txt*
    1~jjjj~kkkgkhfdhg
    hhhghg
    hoghodshgohdsoiahgfhoghojhqgh*
    2~3333~gdskhkgjh
    ghfdgh
    fkjhbdskjhkghdghah*

    )

    IF i import the above data into a table with emp_txt as text data type
    i am getting
    kkkgkhfdhg
    hhhghg
    hoghodshgohdsoiahgfhoghojhqgh
    all in one row like:kkkgkhfdhg hhhghg hoghodshgohdsoiahgfhoghojhqgh.But i should get it same as in the notepad.
    for that i have changed the datatype of the emp_text column as image in my database.
    But when i change the datatype my DTS is giving the following error:

    Error at Destination for Row number 1. Errors encountered so far in this task: 1.
    Insert error,Column3('emp_text',DBTYPE_BYTES),status 2: Error converting value.
    Invalid character value for cast specification.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    In the format file also specify asterisk (*) as a row separator.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •