Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mateo1041
Starting Member
1 Post |
 Posted - 2010-07-06 : 11:15:54
|
| Hi all,I've been using Microsoft SQL Server Management Studio for multiple manual SQL queries for Excel reports up until this point. I'd now like to automate my processes further with Microsoft Business Intelligence Development Studio and generate reports using this rather than Excel.Here's a rough overview of what I'm looking to do:* Combine multiple data sources including SQL Server and Excel data* Generate a report using this combined data* Re-use this report in the future with different criteria and Excel data. While the SQL Server data sources would remain the same, Excel data would change for every report run.My access to the SQL servers is read-only. I'm not an administrator on the PC I have access to due to tight security.I've played around with both SSIS packages and reports, but am not quite sure where to begin. I did create an SSIS package that combines the SQL server and Excel data using a Merge Join transformation, but am not quite sure what to do with the created package or if that package can even be used in a report.Any guidance would be appreciated.Thanks. |
|
|
|
|
|
Looking for guidance with reporting in BIDS