SQL 2008 R2 SSRS 2208 R2 SSIS 2008 R2 I need to run a report in BIDS that displays data for my user based upon a date parameter. If my user likes the data he can then change another prameter in BIDS, and rerun the report. With the new perameter set to "True" I need an SSIS project to be triggered that will output a text file in a specific format and email it to someone. The part of this that I can't figure out is how to pass the date prameter from BIDS to SSIS. I haven't been able to make much since out of my Google. searches. The only thing I can come up with is to have BIDS update a sql table to match the data parameter and then have SSIS read the value from that table. I am sure this not the way it should be done though. Any help would be appreciated.

BIDS is a dev environment - you don't want users viewing reports in that. As for triggering an action from SSRS - the only way that I've ever figured out how to do it is embedding javascript in an Action Go to URLChuck

Sorry, I meant they are running the reports through a web portal with SSRS.

Set the package to consume a configuration (more on that soon), the config type I would use - database table. In the table hold the run time values for the SSIS package. How to add a config: go to the SSIS menu and choose Configuration... follow the wizard and set the database connection up... in short see here http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/Arthur My Blog

Set the package to consume a configuration (more on that soon), the config type I would use - database table. In the table hold the run time values for the SSIS package. How to add a config: go to the SSIS menu and choose Configuration... follow the wizard and set the database connection up... in short see here http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/Arthur My Blog

The link you supplied does not work.

See this one then How to easily add a config: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/66500/Arthur My Blog

See this one then How to easily add a config: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/66500/Arthur My Blog