Row file destination, error data

Question

Row file destination, error data

Alen Cappelletti

Ten Centuries

Points: 1172
More actions
July 5, 2008 at 2:01 am

#123074

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,

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

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

Tim Mitchell SSCoach Points: 15671 More actions · Answer 1

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

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

Alen Cappelletti Ten Centuries Points: 1172 More actions · Answer 2

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

VRT SSCertifiable Points: 5776 More actions · Answer 3

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