12 docs tagged with "task"

Biml version of common SSIS expressions covering strings, dates, and times.

An introduction to transformers in BimlScript, a feature available in BimlStudio.

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.

These are the code samples from the PASS BI Virtual Chapter meeting from 2013/12/12. For the video, check out "Create and Load a Staging Environment...

Generates a master package that runs every '.dtsx' file in a given directory in parallel as ExecutePackage tasks, the standard pattern for orchestrating a load phase produced by a per-table generator.

This Walkthrough presents a very fast technique to build a simple (Truncate and Load) SSIS package by leveraging a SQL Stored Procedure and BIML.

How Biml extends an auto-generated Data Vault to handle business keys, satellite splits by fast-changing attributes, and per-attribute manual overrides driven from metadata.

Embeds a complete ScriptTaskProject (assembly references, ReadOnlyVariables, ReadWriteVariables, and 'ScriptMain.cs') directly inside a Script task instead of declaring it under a shared 'ScriptProjects' root, which keeps automation-generated packages self-contained.

Reads INFORMATION_SCHEMA for a configurable source view to optionally drop and recreate the destination table, then emits an SSIS package that truncates the staging table, optionally drops and rebuilds its indexes via stored procedures, and loads it from the view via an OLE DB source-to-destination dataflow with FastLoad.

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...

An explanation and example of the Merge task.