DayLaborer
Programmer
I am trying to create a DTS package that will execute a stored procedure and save the results into an Excel file. When I use the DTS wizard, I get an error 'Invalid Object Name '#TempDataTable'. Context: Error calling GetColumnInfo.
The stored procedure creates a temporary table called #TempDataTable, inserts rows into it, selects from it, and then drops it. The same error occurs with global temporary tables and I don't have the option of creating a regular table due to permissions.
Are there any other ways to send results of the stored proc to Excel? I tried some ActiveX code I found but it converts decimal fields into a "custom" field which it ends up formatting as a date field.
Thanks!
The stored procedure creates a temporary table called #TempDataTable, inserts rows into it, selects from it, and then drops it. The same error occurs with global temporary tables and I don't have the option of creating a regular table due to permissions.
Are there any other ways to send results of the stored proc to Excel? I tried some ActiveX code I found but it converts decimal fields into a "custom" field which it ends up formatting as a date field.
Thanks!