| Author |
Topic |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-05-30 : 14:21:05
|
| Hi my manager wants me to run my monthly reports off of production automatically. How do I set it up. What information do I need to get started? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-30 : 14:31:12
|
| 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? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-30 : 15:39:38
|
quote:
Originally posted by Joshrinn
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 ssrsjust set a subscription for the report based on schedule and it does delivery automatically. Internally it makes use of sql sgent job for itYou 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-30 : 22:00:28
|
| 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? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-30 : 22:22:44
|
quote:
Originally posted by Joshrinn
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 questionare 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-30 : 22:49:14
|
| 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? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-30 : 22:55:56
|
quote:
Originally posted by Joshrinn
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?
seehttp://msdn.microsoft.com/en-us/library/ms137952.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-31 : 09:56:55
|
| Visakh how can I load excel data into report DB? Please asap |
|
|
|
Joshrinn
Posting Yak Master
118 Posts |
Posted - 2012-05-31 : 12:42:39
|
| 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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-31 : 15:21:32
|
quote:
Originally posted by Joshrinn
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 packageYou should be using indirect configuration method to make sure package deployment works smooth across environmentssee an example herehttp://akashonly.blogspot.com/2010/04/indirect-configuration-in-ssis.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-31 : 15:24:32
|
quote:
Originally posted by Joshrinn
Visakh how can I load excel data into report DB? Please asap
use data flow task available in SSIS with excel source pointing to file and OLEDB destination to point to your DB------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Running reports off of production server