How to get precise error message when processing SSAS through SSIS?

Question

How to get precise error message when processing SSAS through SSIS?

Eric Mamet

SSChampion

Points: 11720
More actions
September 17, 2018 at 9:34 am

#379099

First, please tell me if I am on the wrong forum...
My Server is SQL 2016
I process a SSAS database through an SSIS Package (which I fire on schedule from SQL Server Agent but I think we can leave the SQL Agent aside).
I find that I cannot get the exact SSAS failure error message by looking through the SSIS detail report.
The only way I have found to get the error is to run the SSAS processing myself (through SSMS)
Am I missing a trick?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Hamid-Sadeghian SSC Eights! Points: 890 More actions · Answer 1

Hi
Are you config logging in SSIS package?
Which type of logging is configured in your package?
Please see this link for more information.

Eric Mamet SSChampion Points: 11720 More actions · Answer 2

Not much as far as I know.

We just log a few details we think relevant, that's all.

For the rest, we use the built-in reports

Hamid-Sadeghian SSC Eights! Points: 890 More actions · Answer 3

Eric Mamet - Monday, September 24, 2018 8:40 AM
Not much as far as I know.
We just log a few details we think relevant, that's all.
For the rest, we use the built-in reports

SSIS can log everything very detail in SSISDB. at link that I send to you in previous post, you can how to set logging for ssis to capture everything and each error that occurred during execute package.

Eric Mamet SSChampion Points: 11720 More actions · Answer 4

Hamid-Sadeghian - Monday, September 24, 2018 10:31 AM
Eric Mamet - Monday, September 24, 2018 8:40 AM
Not much as far as I know.
We just log a few details we think relevant, that's all.
For the rest, we use the built-in reports
SSIS can log everything very detail in SSISDB. at link that I send to you in previous post, you can how to set logging for ssis to capture everything and each error that occurred during execute package.

Thanks, I'll have a look