I have script that will compares 2 objects. It produce result similar to windiff. You don't need to export object

posted in scripts http://www.sqlservercentral.com/scripts/Maintenance/64277/

"." was added when cut-and-paste into forum. Statement runs OK, no problem. I does what I need.

Why MS shows it as error. READ error message I have send

"The SQL statement...

this is client's requrement, not mine. He wants daily extracts as  txt file, tab delimited, numbers as 0.00, not qoutable, right justified. In DTS, if you use default transformation it sets strings...

I was looking for the way to keep it as number. Result go to dts and I need manually set it to not quotable and append spaces for alignmnet. You suggestions...

I know I can covert it to string and do any formatting I want, but since all I want is to extract number that are less then 1.0 as "0.75", not as ".75". ...

Bulk insert is better for large files.

In Bulk Insert Task select use Format File and then define formatting with wizard the same way as for text file.