15 docs tagged with "bimlscript.com"

In this webinar, we will introduce you to BimlStudio, BimlScript syntax, and the fundamentals required for you to follow and understand more advanced Biml topics.

A starter kit for creating BimlScript Metadata Driven packages using a Master Data Services back end to store the metadata.

The intellisense for creating Biml and BimlScript files using BimlExpress is limited to Biml only. Currently, there is no intellisense for C# or VB code in a BimlScript document inside Visual Studio.

Walks a directory (recursively or top-only) for '.dtsx' files, sourcing the root path from a 'PROJECT_ROOT' environment variable with a hard-coded fallback, then emits one ExecutePackage task per file inside a single master package.

Connects directly to a live source database with 'ImportDB', then generates one Dataflow task per imported table that copies the data from the source connection to the target connection, with no advance knowledge of the source schema required.

A parameterized child BimlScript (TableName, AuditTableName) that emits a per-table container with an Execute SQL task running a metadata-driven stored procedure plus an audit-log insert, called from a parent script via CallBimlScript to assemble fact and dimension load packages from metadata.

Calls 'ImportDB' against a live source, then filters the returned TableNodes against either a hard-coded C# list or a metadata-driven SQL query, a more flexible alternative to 'ImportDB''s LIKE-style filter when you need to pick disparate table names.

In this webinar we will go through the pattern required to migrate workloads to Azure. This session will be a live BimlScript demonstration with hardly...

When a new Biml file is added to Visual Studio, the editor assumes that all of the code being entered is XML. Since BimlScript is not XML, the editor does…

Learn how to 'roundtrip' your SSIS packages between SSDT and BimlStudio, and take advantage of the extended Biml toolsets.

Demonstrates the 'ErrorHandling' element on a dataflow component, including how to set output-level 'ErrorRowDisposition' and 'TruncationRowDisposition' defaults and override them per column.

Imports a filtered list of AdventureWorks tables, then generates one per-table extract package whose script component reads each column's runtime DataType from the pipeline buffer, serializes the value (including null-handling tokens) into a byte array, and emits a SHA1 hash as a new output column.

Example to demonstrate how easily you can import all the database tables and convert the nulls to defaults.

Transformer that will insert transformations before component.

Describes an end-to-end process for setting up Oracle XE and accessing data from SSIS using the Attunity Oracle Connection with Biml.