Hello,

  I was getting "Invalid Pointer" when trying to export results of a query (from a stored procedure) to an Excel spreadsheet.

The problem was that I had one line in the stored procedure that inserted on record in another table. Then I had set Nocount on. As a result if you ran my qurery Analyzer you would get a message in the message window.

It truns out that DTS packages do not like messages. Make sure you have Set NOCOUNT ON and SET ANSI_WARNINGS OFF.

It took me half a day to figure this out!

Shab