- Feb 2023
-
learn.microsoft.com learn.microsoft.com
-
then select Close
While there is an [ X ] close button for this window, the buttons at the bottom right are OK, Cancel, and Help. There is no close button.
I'd update the docs to say Cancel instead,
-
verify the server name is the instance of SQL Server containing the SSISDB catalog, and the path shows SSIS Tutorial Deployment
My path said /SSISDB/SSIS Tutorial and there didn't seem to be a way to change it - that field was visible but disabled (grayed out).
After pressing the Connect button to the right of Authentication, the Path changed to match the documentation and became editable.
-
On the Select Packages page, you should see all six packages from the SSIS Tutorial. In the Packages list, select Lesson 6.dtsx, then select Next.
At this step I encountered the following error: "One or more selected packages are not ready. Review the Status column for more information."
The Status column said: "Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of Get Error Description is not compatible with this version of the DataFlow. [[The version or pipeline version or both for the specified component is higher than the current version. This package was probably created on a new version of DTS or the component than is installed on the current PC.]] at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)"
I was able to resolve this by changing the value Configuration Properties > General > TargetServerVersion from SQL Server 2022 to SQL Server 2019.
Thanks to a hint found here: https://johnkilleenblog.wordpress.com/2019/10/08/ssis-script-component-mismatch-error/
-