Hi all,

My problem is quite simple. I have a small c# application accessing a DTS
package to read and display info about it. I can access any type of standard
custom tasks and its fields, but I lack documentation about DTSOlapProcess.

DTS.CreateProcessTask2 oCreateProcessTask =
(DTS.CreateProcessTask2)oTask.CustomTask;
Console.WriteLine(" Command line = {0}",
oCreateProcessTask.ProcessCommandLine);

These two lines (assuming that oTask is a valid DTS.Task object) allow me to
print the content of ProcessCommandLine field.

DTSOlapProcess.Task oDTSOlapProcessTask =
(DTSOlapProcess.Task)oTask.CustomTask;
Console.WriteLine(" Filter = {0}", oDTSOlapProcessTask.Filter);
Console.WriteLine(" Incrementally update dimensions = {0}",
oDTSOlapProcessTask.IncrementallyUpdateDimensions ? "Yes" : "No");

These three lines doesn't even compile. Intellisense completes
oDTSOlapProcessTask with .Filter, telling me that it is a string, but when
tring to compile I get this message: "Property, indexer, or event 'Filter'
is not supported by the language; try directly calling accessor methods
'DTSOlapProcess._Task.get_Filter()' or 'DTSOlapProcess._Task.set_Filter(ref
string)'"

The last line with IncrementallyUpdateDimensions (a bool) does work
correctly.

Can anyone help ? Does someone know where I could find documentation about
DTS and OLAP, standing from a developper point of view ?

Regards,

Luc Bolly

Trying referencing the property through the Properties collection, something
like-

Console.WriteLine(" Filter = {0}",
oDTSOlapProcessTask.Properties["Filter"].Value);


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Luc Bolly" <luc.bolly (AT) eu (DOT) sony.com> wrote

Thanks, it seems to work. I am able to obtain the list of properties through
a foreach loop of all properties.

foreach(DTS.Property oProperty in oDTSOlapProcessTask.Properties) {
Console.WriteLine(" {0} = {1}", oProperty.Name,
oProperty.Value.ToString());
}

But despite this small victory, I'm still missing info about the DTS/DTS
Tasks/OLAP/... objects. MSDN is really poor on this and my search on the
Internet is not really fruitful. So if anyone has info, or links to info,
don't hesitate.

Luc Bolly



"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote