How to run SSIS package through the command line?

Dear member,

Does any body know how to run SSIS package through the command line?

Thanks

Shamen

You can use DTEXEC from the command line to run packages.|||

Thanks Jwelch...I will try....

How to retrieve unary operator for member?

Hi to everyone!

How to retrieve the value of the "UNARY_OPERATOR" property for a given dimension member?
MDSCHEMA_PROPERTIES schema contains information about this property but there is no such item in Properties collection of ADOMD.Member object.

I use the final version of SSAS2005 and MSOLAP.3 provider. I connect to server via ADOMD (not ADOMD.NET).
I have just discovered the way, but I think it's rather strange. You can execute a query with DIMENSION PROPERTIES statement like this:

SELECT { [Account].[Accounts].AllMembers } DIMENSION PROPERTIES UNARY_OPERATOR
ON ROWS, { [Category].[Category].Levels(0).AllMembers }
ON COLUMNS FROM [Finance] WHERE ([Measures].[Amount]
)

and needed property value is included in query results.

I'm still looking for another solution...

How to retrieve Member Properties in vb.net 2003 from MS AS 2000

Hi All,

We are facing one problem while retrieving member properties from MSAS 2000 using MDX query in VB.Net. we are able to retrieve the member properties like [Account].[All Account].[Net Income].[Total Expense] but i need the value should come like in this format [Account].[All Account].&[5000].&[5100] which is the member key value.

We are using ADOMD to connect MSOLAP and passing MDX query to retrieve the member properties. The below code which i used to retrieve in VB.Net.

Current Environment is VB.Net 2003 Framework, ADOMD and ADODB.

For intDimCount = 0 To cst.Axes(0).DimensionCount - 1

For intMem = 0 To cst.Axes(0).Positions.Count - 1

arrMem.Add(cst.Axes(0).Positions(intMem).Members(intDimCount).Caption)

arrMem.Add(cst.Axes(0).Positions(intMem).Members(intDimCount).UniqueName)

arrMem.Add(cst.Axes(0).Positions(intMem).Members(intDimCount).Name)

Next

Next

Could you please anyone to advise the same to retrieve member poperties( Name & Unique Name) like this [Account].[All Account].&[5000].&[5100].

Thanks,

Vishwesh

You can control the way the unique name is returned by adding a parameter to the connection string. This KB article explains the details http://support.microsoft.com/default.aspx/kb/304337

In AS2000 I think there was also a registry key setting, but the connection string option is probably better as then your application will be in control of how the unique names are formatted.

|||

Hi Darren,

I am Very thakful to u r reply.It is really helped to solve our Problem.