Create MSI Installer for SSIS Package

Can anyone sugest me steps to create the MSI Installer for SSIS packages

That is a bit of an open question.

I would use WIX to create the MSI. All you need to do is copy the SSIS package file to a folder location.

How you specify the location is up to you, and really depends on yoru requirements.

You could also create a Setup project in VS 2005, if you have it, or use one of the many other third party MSI creation tools.

If you wanted to install the packages in a manged location that would be harder. For the "SSIS Package Store" folder, then just copy the files to the folder. It may get a bit mnessy, but some points to help find that location. Try the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\Setup\DTSPath key to get the root folder. By default the sub-folder you want is Packages, but to be sure you would have to read the SSIS Service config file. To find this look in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile

You may have to write a custom action to handle the manged stores, so for that reason I'd say go with files!

create local cube issue

Hello everyone,

I have a problem in creating the local cube in MSAS2005. This is what I have done please guide me to solve the issue.

Steps:

1. We have installed MSAS2005 with SP1 on Dev box
2. I created cubes on BI Studio (linked to dev box from my local pc)
3. I can see the cubes from MSMS (linked to dev box from my local pc)
4. Then I tried to CREATEGLOBALCUBE myCube

Storage ‘c:mylocalcube.cub’

From myCube

(MEASURE [myCube].[ORDERS],

DIMENSION [myCube].[Time].[Year -Quarter - Month],

DIMENSION [myCube].[All Invoices].[Inv Number])

5. I got error message ’A connection cannot be made. Ensure that the server is running.’
6. MSAS2005 server is running. I can view the cubes from MSMS

Please tell me if I am missing something and also help me to resolve the issue.

Thanks

You are missing a backslash:

c:mylocalcube.cub

should be

c:\mylocalcube.cub

|||Thanks. I forgot type in.

I tried that directly run this MDX query on the server, it works. Somehow can not run cross network, but I can run select MDX query in my box.

Someone have any idea?

Thanks.
|||

Sorry, I don't understand what exactly doesn't work. Let's clarify:

1. Create Global Cube from your machine to the server on your machine : Works

2. Create Global Cube from you machine to the server on another machine: Doesn't

|||Sorry, I didn't say clear.
1.Create Global Cube from the server on server machine: Works
2. Create Global Cube from my machine to the server on my machine: Doesn't
3. I tried : 'SELECT
{[Measures].[Orders]} ON COLUMNS,
[Time].[Year].Members ON ROWS
FROM myCube'
from my machine to the server on my machine: Works.
means Analysis Service is running and connecting, but just not work for 'Create Global Cube'. I really do not understand why.

Any suggestions?

Thanks.

|||Could you make sure that cube file is not opened from any other application and that it's not write protected or something like this? May be just delete this file and try to create it again. The other thing that comes to mind are permissions for directory, but you are obviosly an administrator on your machine and should have permissions to your own c:\ drive. Is it Vista by any chance?|||This file not exists on the server, I want to create it, but no succeed.
I will double check permissions for the directory when server person come.

Thanks a lot Irina. I will post the result later.

By the way, Is there a way can schedule MDX query as a job?

Thanks.
|||I checked permissions for the directory, everyone has read and write permissions at this moment, but I still got same error 'A connection cannot be made. Ensure that the server is running.'

What else I should check? any suggestions?

Thanks.