Knowledge Base

Biml Language

• Protected XML Characters in Biml

  This article identifies the protected xml characters, and ways to still use them in your Biml code

Key Management

• Self-Generating Offline Product Keys

  Step-by-step guide for generating offline product keys

• The Varigence Account Portal

  Details the different sections of the Varigence Account portal and the features within.

Common Issues

• Fixing the DTSRuntimeWrap Error

  A solution for the DTSRuntimeWrap error

• Assembly Name Directive with Custom Library Locks the Target DLL

  Workaround on how to avoid a file lock on the DLL when included in an assembly name directive

• BimlStudio Fails to Open or Crashes Unexpectedly

  Numerous resolutions to known issues relating to BimlStudio application launch and interaction

• Resolving Error: "Could not resolve reference to '[Hash]Output' in property 'OutputPath'. '' is invalid."

  How to resolve the error encountered in BimlStudio: "Could not resolve reference to '[Hash]Output' in property 'OutputPath'. '' is invalid"

• Resolving MSBUILD Error: File Paths Too Long

  Guidance on how to circumvent the MSBUILD error when file paths exceed the character limit

Azure Data Factory

• Adding Headers and Body to Web Activities in Azure Data Factory (ADF)

  How to populate header and body properties to use a Web Activity to call a REST endpoint from inside of a pipeline in Azure Data Factory

Project Creation

• Fixing a Biml Generated Package Using Visual Studio

  How to diagnose missing or mismatched components in a faulty package, and also repair those same issues without having to notify the user

• Building Against a Database That Cannot Be Connected To In BimlExpress

  Guidance on how to create a package that builds against a database that cannot be connected to

Connection Settings

• Determining the Appropriate Version of a SQL Server Instance

  Guide to helping users determine the correct SQL Server instance to connect BimlStudio to

• Submitting a Support Request Dependent on User Environment

  Guidance on allowing Varigence Support to consider a user's data source to replicate issues being experienced by end users

• Connecting to Oracle as a Data Source

  Guide on numerous ways to connect to an Oracle data source using Biml

• Resolving An SSL Provider Authentication Error

  How to resolve an error indicating that an SSL Provider's certificate chain was provided by an authority that is not trusted.

Data Privacy

• Data Protection and Privacy (GDPR)

  Varigence, Inc. adherence to the GDPR EU law regarding personal data privacy

Metadata Extraction

• Extracting Metadata to Provide to Support

  How to configure and export project metadata to share with Varigence support

Installation

• Uninstall BimlExpress from Visual Studio (SSDT)

  A guide to uninstalling BimlExpress from your environment

• Installing BimlExpress

  Guide on how to install BimlExpress

• Installing BimlStudio

  Guide on how to install BimlStudio

• Force Installing Unavailable BimlFlex Runtime Features

  How to install runtime features that BimlFlex is indicating are unavailable

• Installing BimlFlex

  Guide on how to install BimlFlex

• Providing a Temp Log Due to Upgrade/Installation Error

  Where to locate your installation logs after encountering an error during upgrading Varigence products

• Resolving Setup and Installation Errors

  How to Resolve Common Installation and Setup Errors for Varigence Products

• Unable to Upgrade BimlFlex Metadata Database (2022 R2)

  How to resolve the "Could Not Deploy Package" error when updating the BimlFlex database

Data Type Issues

• Parameter Not Updating ('INT' Data Type)

  Providing documentation for common known issue regarding INT data type failure

SSIS

• Simultaneously Run Regular and Delete Detection for SSIS Flat File Import with Archiving Enabled

  How to simultaneously run regular SSIS flat file import processes and delete detection when file archiving has been enabled

• Failed to Retrieve Long Data for NTEXT Datatype Column in SSIS Packages

  Issue with loading columns that have datatype NTEXT. The error message will typically read "Failed to retrieve long data for column"

Purchase & Activation

• Product Key Acquisition and Payment Options

  How quickly product keys can be obtained based on method of payment

Product Support

• Product Support Process and Resources

  Walkthrough of the preferred method of seeking support prior to creating a Support ticket

• Creating and Managing Support Cases

  Guide on how to manage Varigence support tickets through email or Customer Service Portal

• Account Admin Web Role Permission

  Description of the Account Admin Web Role within the Customer Support Self-Service Portal

• Support: SMU vs. Remote Consulting Hours

  Differences between support coverage offered through a contract for Support, Maintenance, and Upgrades and Remote Consulting Hours

Source Control

• Configuring Source Control Functionality within BimlStudio

  Offering two methods on how to integrate source control functionality into BimlStudio, using Azure DevOps or a third-party application.