Deployment Utility or Import Package?

In reference to the question raised in this thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1460591&SiteID=1

Since I'm not able to create a deployment utility, when a config file is shared among multiple packages and also I cannot get the permission from Sys Admins to use Env. Variables I'm struck.

Now I'm thinking of importing the package to Sql Server from the file system. Is there any caveats in this approach? especially regarding the config files?

[edit]
Also, do I need any special permissions to view the Integeration Services node in Management Studio? We are using Integerated Authentication, neither do I'm able to run sp_start_job sp in the msdb database.
[/edit]

Thanks

You might want to look at DTUTIL for deployment. It's a little more work than just building the project in SSIS, but it is more flexible.

With the config files, you just need to be sure they are accessible from the package once it is in SQL Server.

Deploying Analysis service solution

Greetings,

How do I deploy an Analysis services project on to diference machines. I have followed the process laid out in MSDN and changed the server to the remote server name while deploying. It throws up an error that the user does not have permissions to create objects on remote server.

Please help me understanding the process of deployment and how the analysts can open up the deployed cube in their machines

Thanks/Regards

Shiv

You must had the users in the security panel of your remote Analysis Services.

In Microsoft SQL Server Management Studio, open a connection to your Analysis Services Server. Click Right on the name of your server (XXXX (Microsoft Analysis Services...))

Choose Properties, Security, and add the users that must access to your server

|||

Hi,

I am facing the same problem, i did as u said and got the following error:

TITLE: Connect to Server

Cannot connect to myserver.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

An existing connection was forcibly closed by the remote host (System)

BUTTONS:
OK

pls any help ?

Thanks

Tarek Ghazali

MS SQL Server MVP

Deploying Analysis service solution

Greetings,

How do I deploy an Analysis services project on to diference machines. I have followed the process laid out in MSDN and changed the server to the remote server name while deploying. It throws up an error that the user does not have permissions to create objects on remote server.

Please help me understanding the process of deployment and how the analysts can open up the deployed cube in their machines

Thanks/Regards

Shiv

You must had the users in the security panel of your remote Analysis Services.

In Microsoft SQL Server Management Studio, open a connection to your Analysis Services Server. Click Right on the name of your server (XXXX (Microsoft Analysis Services...))

Choose Properties, Security, and add the users that must access to your server

|||

Hi,

I am facing the same problem, i did as u said and got the following error:

TITLE: Connect to Server

Cannot connect to myserver.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

An existing connection was forcibly closed by the remote host (System)

BUTTONS:
OK

pls any help ?

Thanks

Tarek Ghazali

MS SQL Server MVP