July 5, 2008 at 2:01 am
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,
July 9, 2008 at 6:44 pm
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
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
July 10, 2008 at 2:01 am
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
July 10, 2008 at 9:16 am
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