- 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/
-
-
learn.microsoft.com learn.microsoft.com
-
On the Select Properties to Export page, in the Objects pane, expand Variables, expand varFolderName, expand Properties and then select Value.
There doesn't seem to be a way to toggle any of the checkboxes in this step with VS 2022.
When I navigate with the arrow buttons, checkboxes appear, but pressing space or enter, or clicking on them has no effect.
-
- Dec 2022
-
learn.microsoft.com learn.microsoft.com
-
then select Directory.
I don't see an option for Directory in VS 2022. Only Delay Validation, Description, Disable, and DisableEventHandlers start with D.
-
-
learn.microsoft.com learn.microsoft.com
-
select Build Solution
This doesn't seem to be an option in VS 2022. Instead it just allows you to build the project with SC_ followed by a long line of letters and numbers like a GUID but without spaces.
-
-
learn.microsoft.com learn.microsoft.com
-
On the SSIS menu, select Log Events.
Using SSIS Projects for Visual Studio 2022, the Log Events option doesn't seem to do anything. Running through the steps in this tutorial results in a log file with headers, but nothing else.
-
-
learn.microsoft.com learn.microsoft.com
-
On the Provider and Logs tab, in the Name column, select Lesson 3 Log File. After you have created a log provider for your package, you can optionally deselect it to turn off logging, without having to delete and re-create a log provider.
To turn it on and off you need to know to select the checkbox and toggle the checkbox with the spacebar.
-
On the Details tab, in the Events column, select the PipelineExecutionPlan and PipelineExecutionTrees events.
No matter where I click in the package tree, ell options in the Details pane are "dimmed" as the note describes.
There is an alert at the bottom of the window that says: "⚠️ To configure unique logging options for this container, enable logging for it in the tree view."
EDIT: We discovered that selecting the checkbox and hitting space un-mutes the field, then the checkbox can be toggled with the space bar.
With it toggled OFF, you can then go to the Details tab and toggle the settings as required, then go back to the Providers and Logs tab and toggle it ON.
-
In the Containers pane, expand all nodes of the package container hierarchy, and then clear all check boxes, including the Extract Sample Currency Data check box. Now select the check box for Extract Sample Currency Data to get only the events for this node.
When I completed this step, the nodes of the package container hierarchy did not have checkboxes. Also, the Extract Sample Currency Data checkbox did not respond to my clicks.
There was a message to clear the parent, but since the parent had no checkbox, I was unable to do so.
Drilling down resulted in checkboxes that "appear dimmed" as in the note below.
This appears to be a bug or at least a lapse in the documentation.
EDIT: We found a work-around. You can highlight the checkbox and tick it with the spacebar - but you can't select it with the mouse.
On the Lesson 3 root node, under Select the logs to use for the container: I was able to select the checkbox.
When I navigate deeper though, this option is unchecked and muted or grayed out with a message at the bottom reading:
"⚠️ To configure unique logging options for this container, enable logging for it in the tree view."
-