Copy to the folder “%USERPROFILE%\Documents\My Shapes” (“C:\Users\you_user\Documents\My Shapes”; that is the default folder for the Visio custom shapes)
To access the shapes in Visio, select the Shapes Windows:
“More Shapes -> My Shapes -> Microsoft Integration Stencils v#.#”
“More Shapes -> My Shapes -> MIS Apps and Systems Logo Stencils v#.#”
“More Shapes -> My Shapes -> MIS IoT Devices Stencils v#.#”
“More Shapes -> My Shapes -> MIS Support Stencils v#.#”
This might take a minute or two depending on your connection speed. Once done, i can run this command to see how many Az module version i have installed;
Get-InstalledModule -Name Az -AllVersions | Select-Object -Property Name, Version
Since i have only a single version installed, so that’s what i see. if i had multiple versions installed, i would have seen many lines. By default, PowerShell uses the most recent version.
This concludes installation of Az module into PowerShell.
Time to do some good stuff. Run this command to connect to Azure;
Connect-AzAccount
This will open up browser and ask about your credentials. After verification it will show that your session is authenticated. Navigate back to PowerShell an you can see authentiation message.
If you have multiple Active Azure subscriptions, First one will be selected by default.
Run an azure resource command to confirm PowerShell is working;
Get-AzVM, Get-AzWebApp
Switching to another subscriptions
Run this command to see all of your subscriptions;
Get-AzSubscription
You will see a list of assigned subscriptions. To switch to another subscription, store your subscription in a context variable and switch the context.
$context = Get-AzSubscription -SubscriptionId <Subscription ID from list of subscriptions>
When I run integration services package from inside of the windows box, they work. When I try to run them from outside of the box using my laptop, they fail. SQL Agent job works from either side.
Upon further investigation, I noticed these events in windows system event log;
It seems that DistributedCOM component has permission issue; Add user’s to this window group;
Now we need to perform some DCOM component configuration to grant access to the Integration services service.
Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying settings in the registry.
On the location tab, make sure “Run application on this computer” is checked.
On the security tab, click Edit in the Launch and Activation Permission area. Add users and assign appropriate permissions, and then click ok.
this link is helpful https://www.timmitchell.net/post/2016/11/28/a-better-way-to-execute-ssis-packages-with-t-sql/
How to script out packages http://tomaslind.net/2015/12/07/ssisdb-catalog-create_execution/
ErrorDescription Error 0xC0012050 while executing package from project reference package “STG_SETO_MilestonesImport.dtsx”. Package failed validation from the ExecutePackage task. The package cannot run. .
