October 18, 2010 at 12:49 pm
I am looking for some ideas on how I can export large amounts of data to .csv or excel. There are users that are needing ot export reports that consist of around 300,000 records. I know there usually isn't a reason for people to have to export this much data, but they do for auditing purposes. I am banging my head in finding a way to make this happen. The report renders fine but times out when exporting to .csv or excel. Any suggestions on how this can be done would be greatly appreciated. Thank you.
October 18, 2010 at 1:23 pm
Sounds more like a job for SSIS than Reporting Services. Unless it absolutely must be rendered through RS, I'd go with an SSIS package. If they're asking for it in a .csv, they'll probably never know the difference anyway.
October 18, 2010 at 1:45 pm
Can I create a SSIS Pacakge that willl run a Stored proc that I can pass parameters to? Thanks
October 18, 2010 at 1:51 pm
tchovanec 65734 (10/18/2010)
Can I create a SSIS Pacakge that willl run a Stored proc that I can pass parameters to? Thanks
Yes absolutely. Additionally, you could look at BCP as a means of getting you data to a .CSV. There are a number of ways to accomplish this, but SSRS is probably not the best way. Here's a somewhat high level discussion of the SSIS execute SQL Task which you'd use to call your stored procedure including how to pass in variables and such...
http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx
-Luke.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply