Post reply

Piped delimited file

  • January 8, 2010 at 5:09 am

    #219086

    I need to extract data from SQL server to piped delimited file. I am having problems with some fields. Usually, the are defined as Varchar(35) and contain alphanumeric data ranging in length from 9 - 35 characters. It will export the 9 character length field just fine and drop data with 35 chars(?). I have tried using the export wizard and then manually setting up my own ssis package...with a without an intermediate data conversion step. I am using sql server 2005. Note: If I do the extract to an excel file, the extract works just fine. I am only having this problem with pipe delimited files. What am I doing wrong? Any help would be appreciated.

  • January 8, 2010 at 9:12 am

    #1100960

    Can you elaborate what do you mean by "drop data" ?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 12, 2010 at 6:44 am

    #1102363

    Instead of having data in the field, or truncating data, field is now blank. I have no idea why.

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

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