April 24, 2013 at 8:55 pm
I have one task, The task having stored procedure and
the task will be run daily and insert the data into Excel sheet.
Regards,
Subash.
April 25, 2013 at 1:12 am
subbareddyap (4/24/2013)
I have one task, The task having stored procedure andthe task will be run daily and insert the data into Excel sheet.
Regards,
Subash.
What is your question?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 26, 2013 at 2:55 pm
Even i didn't understand your question, can you explain it clearly?
Harini
April 26, 2013 at 11:40 pm
Hi Harini,
I have a stored procedure, that procedure will be run daily and provide the result data into excel.
So here i need put SSIS package for this task.
The question is "How to convert the data from stored procedure to excel. What are the transformations i need to used in this task?"
Warm Regards,
Subbu.
April 29, 2013 at 8:17 am
I suggest you read these 2 links
So the real challenge is getting the data out of the stored procedure. You could build a work table and then
INSERT INTO dbo.WorkTable
EXEC dbo.StoredProcedure
Then you can SELECT columns FROM dbo.WorkTable to feed your data into an SSIS data flow and then flow that down to an Excel destination.
April 29, 2013 at 8:25 am
Daniel Bowlin (4/29/2013)
I suggest you read these 2 linksSo the real challenge is getting the data out of the stored procedure. You could build a work table and then
INSERT INTO dbo.WorkTable
EXEC dbo.StoredProcedure
Then you can SELECT columns FROM dbo.WorkTable to feed your data into an SSIS data flow and then flow that down to an Excel destination.
A data flow can quite happily consume the results of a stored proc as an OLE DB source without the need for a work table.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply