Hi,

We're using SQL 2000 (SP3) and exporting data to Excel which gets
emailed to our suppliers.

This package was working fine for about 3 days before we started
noticing that a couple of columns the data is being sent as 0. When we
rerun the DTS package, all is fine. There are about 3 number columns
and one of it is fine. The other 2 gets exported as 0. Does anybody
know of any reason why this is so? We tried changing the format of the
columns and still the same problem.

The same query from Query analyzer works perfectly. The 2 columns that
come over as 0 to Excel are subqueries to the main query but this
works in Query Analyzer.

Any and all help/guidance will be appreciated.

AG