I have an Excel task which is providing error text through the GUI, but I don't know how to access the error task without the GUI and the error disappears if I move the cursor from the X
enter image description here
I have the project property Run64BitRuntime set to False (though it is not editable so even if I wanted to, couldn't change it to true)
-
By the way, installing the accessDatabaseEngine resolved the issue. While most people reporting this had 32bit office installed with no 64bit driver, I had 64bit installed with no 32 bit driver. The Run64BitRuntime=Falso was causing SSIS to run the 32 bit office driver which was not installed.Thronk– Thronk2013年09月13日 01:37:02 +00:00Commented Sep 13, 2013 at 1:37
1 Answer 1
Design-time errors, warnings, and informational messages show up in the Error List pane, which can be shown by going to View | Error List.
enter image description here
-
1I was really hoping this would solve my problem but alas... The Error List is empty even though I have a task with an Error emblem and the leading half of an error message in a tooltipAPC– APC2019年05月13日 17:26:16 +00:00Commented May 13, 2019 at 17:26
-
2@APC, more than a year after your comment, I can confirm that design-time error messages are still not shown in the error list in the latest versions of the tools (Visual Studio Professional 2019 v 16.3.7 with extension SQL Server Integration Services Projects v 3.9.Marc Sigrist– Marc Sigrist2020年09月17日 15:44:07 +00:00Commented Sep 17, 2020 at 15:44
-
I manipulated a value in the Advanced Editor and now I'm getting Validation Warnings. These are neither Warnings or Errors.mherzog– mherzog2023年05月15日 15:16:01 +00:00Commented May 15, 2023 at 15:16