May 2, 2012 at 5:26 pm
I installed Microsoft SQL Server 2005 standard edition.
I need to create an excel file on a daily basis maybe twice a day.
I need to do this automatically if possible, I know I can run a query from Sql Server Agent, but I need it to create the file.
I realized that I don't have Microsoft SQL Server 2005 Reporting Services installed.
Where can I get this, or is there a better option.
May 2, 2012 at 5:37 pm
The 2005 Standard Edition comes with all of the sql sub-systems (SSRS, SSIS, SSAS, and BIDS...).
Your setup will give you the option to install the SSRS piece, or to install it and not activate it at that time.
You will need to run setup again - nothing additional should be needed other than your particulars for the environment you want put in place.
May 3, 2012 at 7:22 am
SSRS wouldnt be the tool for this unless you had a report setup on a subscription which exported the report to a excel file stored on a file share daily.
You would want to use something like SSIS or BCP (ETL tools) to extract data from SQL into files from the DB
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply