June 30, 2011

How To – Tasks and Transformations: Execute Package Task

The Execute Package task in SSIS enables reusable workflows by running one package from another. This post covers its role in archiving, disk space monitoring, and BIDS vs. Mist.

May 31, 2011

Copy Data Dynamically with BimlScript

BimlScript automates SSIS package creation for dynamic data transfers, applying WHERE clauses for filtering.

May 26, 2011

Creating Tables using Biml and BimlScript

Biml can define tables and generate SQL tasks to create them in SSIS. By separating table definitions into one Biml file and BimlScript in another, you can dynamically create tables and automate the process using ExecuteSQL tasks in SSIS.

May 19, 2011

How To – Tasks and Transformations: Foreach File Loop

The Foreach Loop Container in SSIS lets you iterate over files using wildcards for operations like archiving.

May 11, 2011

How To – Tasks and Transformations: File System

The SSIS File System task allows efficient file and directory operations like copying, creating, deleting, and setting attributes, with integration support in Mist for seamless workflow management.

May 5, 2011

How To - Tasks and Transformations: Execute Process

The Execute Process task in SSIS allows running external applications or batch scripts, with dynamic argument handling and integration in Biml and Mist for flexible workflows.