August 30, 2005 at 1:06 pm
I am looking to create a task where I load a table with a stored procedure. upon success, I would like to take the data in that table and convert it into an .xls format.
I thought that this would be easy, and I am able to run the stored procedure, but I don't know how to do the data conversion from there.
I am appreciative of any help.
thanks much,
Mike
August 30, 2005 at 1:55 pm
something very similar was discussed in another post not too long ago..see if this helps:
**ASCII stupid question, get a stupid ANSI !!!**
August 30, 2005 at 5:02 pm
Mike,
You could create a DTS package that runs the stored procedure in an Execute SQL task, then on success export the data from the table to Excel with a Data Transformation task. Roughly, it would look like this:
Execute SQL task ========>> Data Transformation task
(stored procedure) (success) (export to Excel)
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply