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

License and Account Management

• Self-Generating Offline Product Keys

  Step-by-step guide for generating offline product keys

• Account Admin Web Role Permission

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

• The Varigence Account Portal

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

• "System.ConfigurationErrorsException" Product Key Activation Error

  Users may encounter a System.ConfigurationErrorsException error upon entering a product key in the BimlStudio Product Key Activation dialog box.

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"

Support Resources

• 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

• SMU vs. Remote Consulting Hours

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

• Controlling Nullability in BimlFlex Create Table Statements

  BimlFlex column nullability explained: control it automatically or via custom settings for precise CREATE TABLE statements.

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.

Performance Issues

• BimlFlex Performance Issues when using Serverless Databases for Metadata

  A place to start if you use BimlFlex with a serverless metadata database and are experiencing performance issues.

Policies and Procedures

• Product Key Acquisition

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

• Purchase Options and Payment Terms

  Varigence's various purchase options, as well as default payment methods, payment terms, and flexibility therein.

• Product Key Disablement Policy

  Detailing the Varigence Product Key Disablement Policy due to non-payment

• Technical Support Policy

  The Varigence Technical Support Policy addresses requirements to receive support, its coverage policy, its limitations, and additional resources available.