Brian Seib (5/30/2013)
Looking at another server that is runnig the same script and the error it is getting is "COUNT field incorrect or syntax error [SQLSTATE 07002] (Error 0). The step failed". Keep in mind these were working a few months ago, just started getting errors. Very strange.
Error: 07002 Number of columns does not match number of host variables.
http://msdn.microsoft.com/en-us/library/aa176407%28v=sql.80%29.aspx
Have a look how many columns you selected for an insert.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/