Sql Server Syntax Error During DataTransformationService Export..

I am trying to do the DTS export from SQL server 2000 to spreadsheet.Every single time i am getting the error
[Microsoft][ODBC SQL Server Driver][SQL server]Syntax error converting the nvarchar value '1version=9' to a column of datatype int.
it retrieved some row,i can see that in preview but it failed at some row number..So to see the exact row or where its stopping i ran the query under view (Databases->DBname->New->View)
it retrieved some row and stopped at row with custid 1947 .there are 50000 rows in a table..
i changed the query by adding 'AND (dbo.Customer.CustomerId > 1947)'..i changed the  number 1947 to other numbers too..
SELECT     dbo.Customer.CustomerId, dbo.Customer.Email, dbo.ShippingAddress.CustomerId , dbo.ShippingAddress.Country
FROM         dbo.Customer INNER JOIN
                      dbo.ShippingAddress ON dbo.Customer.CustomerId = dbo.ShippingAddress.CustomerId
WHERE     (dbo.ShippingAddress.Country = 1) AND (dbo.Customer.CustomerId > 1947)
i don't see any problem with the rows after 1947 (but obiviously i am missing to notice something!)..but i keep
getting this error and i am not able to proceed at all.Is there any kind of error log i can see??..i am running it on server and not on my local
machine.I would highly appreciate any guidance regarding this.
thanks,