Question on packages deployment

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the deployment of the packages to integration services server. Why after I have deployed the whole solution, but my packages are not actually deployed to the integration services server?

Also, after we add the package manually to the integration services server, to users outside of local host, how could we add permissions for them to execute the packages?

Thanks a lot in advance for your help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hi Helen999888,

I'm not sure how you are deploying the packages or what you mean when you say "add the package manually". Can you provide some detail about your current procedure?

I like to use the Deployment Utility for deployment. In Solution Explorer, right-click the project name and click Properties. On the Deployment Utility page, set the CreateDeploymentUtility property to True. The next time you build the project, a Deployment subdirectory will be created under the bin directory in the project path. Inside this directory will be at least two files: one for each package in the solution and another named the same as the project with the extension: SSISDeploymentManifest. If you double-click the SSISDeploymentManifest file, the SSIS Deployment Wizard starts and will walk you through deploying the package(s) in your project.

There are many ways to execute SSIS packages:

Manually - in either Business Intelligence Development Studio or using DTExecUI. Command Line - using DtExec. SQL Agent Job - using the SQL Server Integration Services step type.|||

Hi, Andy,

Thanks a lot for your advices and help.

With best regards,

Yours sincerely,

Question on Integration of SSRS 2005 Graphs into Sharepoint

I have been assigned to work on a dashboard (see jpg below) which will hook into our Intranet on SharePoint 2003. I have a few questions as in teh approach and what is possible by creating charts through SSRS 2005 report(s):

http://photopizzaz.biz/dashboard.jpg

1) what technique to use to show all 4 graphs simultaneously on the same page in SharePoint Webparts? Is WebParts the best way here to accomplish this?

2) Eventually, they want to be able to click through on the graph parts such as bars, etc. and perform clickthrogh using Reporting Services. How can this be seupt on graphs like these? What is the approach and requirements in Designer...how to do this?

Hi,

We did a dashboard using sharepoint services, and we segmented the screen in two different zones calling 2 static report containers, in which we set subreports. Therefore, as soon as you have defined your 2 containers, if you want to modify the content you don't have to set your changes in sharepoint, you just have to modifiy the subreport link.

For the link through graph parts, I use popup links.

Check your mail, I send you a printscreen

Regards

Ayzan

|||

I have never touched Sharepoint. My boss expects this done in 2 days. Could you walk me through in detail how you created the report containers and how you linked the subreports to them...and if you used one .rdl period for all the subreports or one .rdl for each graph? I am new to all this so any help would be greatly appreciated to help me walk through this for the first time.

When you create those containers, you're saying it just points to the .rdl via a link somehow and renders the report in that container?

Did you create one report then the rest subreports or all subreports? (I don't even think all subreports is possible, but just wanted to find out)

|||

Azyan,

When you say you defined 2 zones, you mean 2 columns in the WebParts layout for the .aspx page?

|||

First check

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=239997&SiteID=1

Ayzan

|||

Yes 2 columns ... 3 if you need a menu.

For each graph you will desing in SSRS, we tried to respect these dimensions

11cm/8cm to display 4 graphs -> 1cm between each graphs

1 2

3 4

23cm/8cm for 1 graph

1

2 3

or

1 2

3

For each line, we set "a container" which is a report calling 1 or 2 subreports. Once configured the containers (dimensions in pixel, tool bars ....), it will be not necessary to set them again. You will just have to modify the subreports called and republish the containers and the subreports.

regards

Ayzan