Dynamics 365 Customer Engagement
Using Script Component to specify input value to OLE DB Source Component in SSIS
Recently we had a requirement to write an SSIS package that will fetch the data from SQL Server and will insert it (or create…
Tag: Script
Dynamics 365 Great Plains
Script to Insert Microsoft Dynamics GP 2018 R2 Missing Security – azurecurve
Each version of Microsoft Dynamics GP which is introduced sees additional functionality introduced; often this additional functionality means new windows are created. Tis in…
Dynamics 365 Great Plains
SQL Script to Disable Business Analyzer Fact Pane – azurecurve
When the Reporting Tools are deployed for Microsoft Dynamics GP a fact pane is enabled in the navigation lists, which gives access to the…
Dynamics 365 Great Plains
SQL Script to Change Compatibility of All Databases – azurecurve
When moving databases between servers for an upgrade of Microsoft Dynamics GP, you will, when also upgrading SQL Server, need to change the compatibility…
Dynamics 365 Great Plains
SQL Script to Change Database Owner of All Databases – azurecurve
When moving databases between servers, you need to make sure the databases are set to have an owner of DYNSA. Rather than dong this…