Search Results

Recently, I experienced an issue where a custom destination component in SQL Server Integration Services (SSIS) was failing in Visual Studio. The component worked fine when the SSIS package was deployed to the server and worked at design time in designing the package. Very strange to say the least. Why would the package success at design time in Visual Studio, execute successfully when deployed to the target SQL Server, but fail at runtime in Visual Studio when the developer was testing? After much troubleshooting, we finally found an answer. Details below on the error and solution for anyone who encounters this! Version Info Visual Studio 2017 (15.9) SQL Server 2019 Note: this issue likely could occur in Visual Studio 2019 as well. We originally started to use Visual Studio 2019 but abandoned it was that version as SSIS as an extension, which we thought could be a factor in our original error. Error [SSIS.Pipeline] Error: Cannot find the connection manager with ID "{13E04AC8-6375-4328-A1CC-71AAB3AAAF21}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "MyCustomComponent.Connections[CustomConnectionManager]" in the connection manager collection of "MyCustomComponent". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID. Solution Ultimately, the solution required installing SQL Server 2019 and Integration Services into the same VM where the developer was working in Visual Studio. It appears that the Visual Studio installer was missing required libraries and executables to pick up the custom connection manager that the custom destination component was using. This explains why the package would succeed on the server as the full SQL Server installation contained all the necessary references.

Microsoft recently released the first version of the 2022 Release Wave 2 for Power Platform and Dynamics 365. Here is a quick article of what I am most looking forward to being released. Detailed plans below Microsoft Dynamics 365 2022 release wave 2 plan overview | Microsoft Docs Microsoft Power Platform 2022 release wave 2 plan overview | Microsoft Docs Features I am looking forward to:

Quick post about a simple, browser agnostic tool for opening the Table Browser more easily in Dynamics 365 Finance and Operations. Ever want to look at data in the table browser but you cannot/will not install a browser extension? Create a bookmarklet! What is a bookmarklet? A bookmarklet is a browser bookmark that contains JavaScript code, rather than a URL. This code when executed can automate actions on a page, prompt for information, and more. The below bookmarklet will allow a user to store the root URL to a Dynamics 365 Finance and Operations environment. It will then prompt for a short name and a table name to take the user to the table browser! How to use the "Go To Table Browser" bookmarklet Click on the bookmarklet JavaScript prompts for the short name of the environments you defined Next it prompts for the table name A new tab will open (if it does not, check your popup blocker!) taking you to the table browser in the environment and table specified. How to create I would love to give this bookmark out but...it's unique to each situation. Thus, you will have to create this yourself. The following will walk you through how to do this. Start by copying the code below into a code or text editor. Replace the URL in each CASE of the switch statement Rename the CASE for the short name of your environment Remove any CASE that are not needed. Next, minify the code by pasting into an online JavaScript minifier (such as https://jsminify.org/) to make the code into a single line. 🔑 This is key to making the code "paste-able" into the bookmark URL. Once the code is minified, create a new bookmark, and paste the code into the URL attribute Your bookmarklet should be ready to go! Try it out! Note: This bookmarklet assumes using the users default Company. It could be extended to add another prompt for Company. Code javascript: var rootURL, name, environment = prompt("Environment? (Dev1, Dev2, Build, UAT, Prod)", ""), errorMessage = "No Error"; switch (environment) { case "Dev1": rootURL = "https://{replaceme}.cloudax.dynamics.com"; break; case "Dev2": rootURL = "https://{replaceme}.cloudax.dynamics.com"; break; case "Build": rootURL = "https://{replaceme}.cloudax.dynamics.com"; break; case "UAT": rootURL = "https://{replaceme}.cloudax.dynamics.com"; break; case "Prod": rootURL = "https://{replaceme}.cloudax.dynamics.com"; break; default: rootURL = "ERROR", errorMessage = "Invalid Environment Reference" } "ERROR" == rootURL ? alert(errorMessage) : (name = prompt("Table Name?", ""), window.open(rootURL + "?mi=SysTableBrowser&prt=initial&limitednav=false&tablename=" + name.toLowerCase()));

My Portfolio Various projects I have worked on over the years Architecture 2021, 2015 Cost Data Warehouse Cost Data Warehouse for manufacturing production insights to break out true elements of cost throughout multiple levels of subassembly production. Multiple versions exist. See details Information access 2017 Heritage Lakes Estates Condominium Assn. Website Modernized communication with homeowners in the community by posting key information and documents. Prior to launch of website, homeowners in the community would need to wait for an email response to answer basic questions and receive various documents. Go to website Architecture 2019 Marketing Interface Design eCommerce Interface utilizing SSIS and JSON based REST web API calls. See details Process improvement 2019 New Start Dog Rescue Website Website I architected to help a local non-profit dog rescue manage their own changes. This saved costly updates by a professional website design firm while still meeting their needs to find volunteers fosters, and adoption candidates. Setup the overall layout and trained the Board on updating design elements to meet the look they desired. Go to website Architecture 2017 Time Collection System Time collection system design and development using Dynamics CRM, SQL Server Integration Services, SharePoint, and Reporting Services. Includes Time Sheet for manual entry labor and Time Clock for clock in/out See details Process improvement 2018 XRM Solution Dependency Checker (XRM Toolbox Plugin) Lead the design of a plugin in the popular XRM Toolbox community tool supporting Microsoft Power Platform (and legacy "xRM"/CRM). Used in the deployment lifecylce to validate that solution contains all necessary dependencies. Eliminated failed solution deployments due to missing dependencies. Over 30k downloads. Go to plugin page SQL 2021 Go To Looper Article I wrote for SQL Server Central (750,000+ subscribers) regarding a technique in SQL Server using GoTo for looping. Go to website Process improvement 2020 Interview Guide Developed an interview guide process. This process improved hiring efficiency in our interview process for technical candidates. Included a three-phased approach using Microsoft Teams to initially screen, technically screen, then finally interview on-site. Both candidates and internal team members appreciated the transparent process. This enabled the team to more effectively gauge talent in a consistent manner. Download Process improvement 2019 New Start Dog Rescue Automation Saved 100's of manual hours generating a printable application form from a Google Forms response by implementing the GSuite tool called Autocrat. Autocrat allows for workflow automation in the GSuite. Particularly in this instance, used Autocrat to generate a printable document from a Forms response collected in Google Sheets. See details Information access 2016 Object Change Log Design and implement a system to automatically track all changes to production code (SQL, C# library, JavaScript, etc.) to support IT change audit. Read more about how this is accomplished. See details Architecture 2012-Present XRM ERP Designed, lead, and engineered a custom ERP application built on top of CRM/XRM/CE/Power Platform for a global electronics distributor and manufacturer with operations in 26 different counties. See details

XRM ERP 2012-Present Designed, lead, and engineered a custom ERP application built on top of CRM/XRM/CE/Power Platform for a global electronics distributor and manufacturer with operations in 26 different counties. < Previous Work Built an ERP application using CRM/CE/XRM/Power Platform as the development platform with components in SQL Server, SharePoint, SSIS, SSRS. Project incorporated dynamic JavaScript libraries and custom C# plugins to acheive the look and feel of a full-featured ERP application. Modules included prospecting, sales, purchasing, inventory management, manufacturing, product configuration management, finance, and logistics. Numerous third parties were integrated for real-time duty rates, daily exchange rate retrieval, and integration to 3PL warehouse. Next Work >

Feb 25 2 min Open the Table Browser with a Bookmarklet | Dynamics 365 Finance & Operations Jul 7, 2021 3 min GoTo Looping in SQL FEATURED POSTS Never Miss a New Post. Enter your email Subscribe Thanks for subscribing! THOUGHTS Jul 13 1 min Power Platform 2022 Release Wave 2 Power Platform Release Wave 2 overview 11 views 0 comments Post not marked as liked Feb 25 2 min Open the Table Browser with a Bookmarklet | Dynamics 365 Finance & Operations Open the Dynamics 365 Finance and Operations table browser without installing an extension! 20 views 0 comments 1 like. Post not marked as liked 1 Dec 9, 2021 2 min Get Choice Label / Option Set Label (Dataverse Reporting) What are Choices in Dataverse? Also, and formerly, known as Option Sets and Picklists, Choices are effectively a key-value pair object... 278 views 0 comments 1 like. Post not marked as liked 1 Jul 7, 2021 3 min GoTo Looping in SQL Overview of GoTo looping technique in Microsoft SQL Server 40 views 0 comments 1 like. Post not marked as liked 1 Jun 25, 2021 2 min Quick Tip: SQL Transaction Log Management Transaction log growing out of control? Encountering error "The transaction log for database is full" Find out how to fix in this post! 10 views 0 comments 1 like. Post not marked as liked 1 Jun 4, 2021 1 min In case you missed it: Microsoft Buys Corp.com A critical cybersecurity action from Microsoft to help the masses went relatively unnoticed. See the below article from ZDNet describing... 4 views 0 comments Post not marked as liked Jun 3, 2021 1 min Dynamics 365 F&O Enums | Project | Project Type As a helpful quick reference to the production order status. 25 views 0 comments 2 likes. Post not marked as liked 2 More Posts ABOUT ME Technology consultant with a focus on business applications. I drive organizational change, solve business problems, and improve processes using technology and creative problem solving techniques. Excels in the design, architecture, development, implementation, and support of business application solutions. Utilizes in-depth technical knowledge, combined with expertise across a broad range of technologies, businesses, and industries, to solve client challenges. Experience partnering with entire client organizations, from manufacturing floor workers, to accounts receivable clerks, to C-level executives. Manages all aspects of the software development lifecycle as a key resource and adviser to both clients and team members. ​ Specialties: -Business Application Design & Architecture -Requirements Gathering -Business Systems Analysis -Power Platform -Microsoft 365 -Dynamics 365 -Azure -Teams -Data Analysis -Business Process Improvement -SQL Server (SSIS, SSRS, T-SQL) Read More > SUBSCRIBE Enter your email Subscribe Thanks for subscribing! Favorite Blogs Name Focus CRM Tip of the Day Microsoft Dynamics, Power Platform Corterra Solutions Microsoft Power Platform, Teams, Microsoft 365, Azure SQL Authority (Pinal Dave) SQL Server Jukka Niranen Microsoft Power Platform ("CRM") Brent Ozar SQL Server Favorite Books Title Author Topic The Art of War Sun Tzu Business 100 Things Every Designer Needs to Know About People Susan Weinschenk Solution design & architecture Doughnut Economics Kate Raworth Economics Extreme Ownership Jocko Wilinek Business How to Win Friends and Influence People Dale Carnegie Business Feature Engineering Bookcamp Sinan Ozdemir Data science Systems Design Interview Alex Xu Solution design & architecture Way of the Wolf Jordan Belfort Business The Goal Eliyahu M. Goldratt Process improvement Solve For Happy Mo Gawdat Mental health