Yes I am using SSRS but could you give me some info regarding it. Also how do I set up my report or run it off of production DB. What all I need to start this process I mean what all access?
Yes I am using SSRS but could you give me some info regarding it. Also how do I set up my report or run it off of production DB. What all I need to start this process I mean what all access?
thats known as subscriptions in ssrs just set a subscription for the report based on schedule and it does delivery automatically. Internally it makes use of sql sgent job for it
You need to make sure you deployed reports as well as dependent objects like datasources to production server first and also set proper credentials.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Thankyou Visakh. And also if they want my reports to run off of production do I need to deploy my SSIS packages to the production server as well since that is what populates the tables for my reports? If yes than how do I copy the dtsx files from my QA folder to the production folder? They need to provide me with the production folder path or no? And what all do I need in order to put my dtsx files in production and Set up a SQL job? I was also planning to put the data source as production server in my report's source source. Is that a good option?
Thankyou Visakh. And also if they want my reports to run off of production do I need to deploy my SSIS packages to the production server as well since that is what populates the tables for my reports? If yes than how do I copy the dtsx files from my QA folder to the production folder? They need to provide me with the production folder path or no? And what all do I need in order to put my dtsx files in production and Set up a SQL job? I was also planning to put the data source as production server in my report's source source. Is that a good option?
yes you've to deploy SSIS packages as well. But one question are you planning to use same server for SSIS and SSRS in production? For deployment you just need to create deployment utility and give it to your DBA and they can deploy it in production using it. You might also need to send configuration files also if you're using it
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Yes I am planning to use same server for both SSRS and SSIS . And how would I create the deployment utility? Does that also mean that I do not have to deploy the dtsx files myself into production if I create the deployment utility. Can you tell me how to create it please?
Yes I am planning to use same server for both SSRS and SSIS . And how would I create the deployment utility? Does that also mean that I do not have to deploy the dtsx files myself into production if I create the deployment utility. Can you tell me how to create it please?
While changing the destination to the prod I first went into the package configuration and removed it in QA environment which I will add later once I open it up from Production. The only thing on my mind is that I have log files in the package. Do I change them to the new prod folder as well? Or how do I deal with the log files which are now in my QA environment
While changing the destination to the prod I first went into the package configuration and removed it in QA environment which I will add later once I open it up from Production. The only thing on my mind is that I have log files in the package. Do I change them to the new prod folder as well? Or how do I deal with the log files which are now in my QA environment
you should not be removing and readding the configurations. That defeats the whole purpose of using them in first place. The intention behind usuing them itself is to change properties at runtime without editing the package You should be using indirect configuration method to make sure package deployment works smooth across environments see an example here http://akashonly.blogspot.com/2010/04/indirect-configuration-in-ssis.html
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Running reports off of production server
Posted - 05/30/2012 : 14:21:05
