Row file destination, error data

  • Hi....I got this problem.

    My datatask is made by 2 step.

    8

    1) SQL server source (is a simple query from a view, 5 column: int, int, bolean, dttime, dtime)

    2) raw file destination.

    With surprice my raw file have 33 line, ok alla the linse, but are at 0 values.

    0 NULL NULL err err

    0 NULL NULL err err

    I don't know if there is some particular tunning the make extraction always succesfull.

    This one is the only task that failure (when I import) of all 33 that build the package.

    Alen Italy,

  • I believe you are confusing the raw file destination with the flat file destination. A raw file is a special kind of SQL Server data file storage, and is a proprietary binary (not text) file. If you open a raw file with a text editor, you will see a bunch of garbage because it's not meant to be used that way.

    Try switching your destination to a Flat File destination and you should get your expected output.

    Hope this helps,

    Tim

  • NO I kwnow...I put on the connection between 2 task a visial editor for the contsnts of the row...So I see null and ZERO values on INT fields

  • Tim Mitchell (7/9/2008)


    I believe you are confusing the raw file destination with the flat file destination. A raw file is a special kind of SQL Server data file storage, and is a proprietary binary (not text) file. If you open a raw file with a text editor, you will see a bunch of garbage because it's not meant to be used that way.

    Try switching your destination to a Flat File destination and you should get your expected output.

    Hope this helps,

    Tim

    Hi,

    I agree with Tim. As he said raw file is a special file and it store the data a binary data which we cann't understand.

    Just try with flat file and check whether the data is coming correct or not.

    Thank You

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

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