Hey guys!
I've been successful getting the Custom SSIS Admin Task to process a Dimension using a SQL staging table. However, we have a few dimensions that are best managed in the Excel Member sheets. When we have changes to these member sheets, is it possible to process the dimension using the SSIS Admin Task. If so, how do I go about doing this? What settings do I need to use within the task?
I've tried using the "Scheduled Members Process" option (I honestly don't even know what this option does and I've found no documentation), but when this option is selected the task simply fails without any messages. And I've tried putting the path directly to the Member Spreadsheet in the "SQL Source Table" box. Using this method, the package returns a successful status code, but it's not really processing anyway. It finishes in less than 2 seconds.
Thanks much!
Sean