Skip to content

The Dynamic Column Task provides the ability to import flat files with varying column structures into SQL Server tables.

Notifications You must be signed in to change notification settings

ClementsDataIntegration/DynamicColumnTask

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 

Repository files navigation

Dynamic Column Task for SSIS

Version: 1.0.0.0
Publisher: Clements Data Integration

Description

The Dynamic Column Task extends SQL Server Integration Services (SSIS) with support for dynamic column handling.
It enables SSIS packages to adapt to changing input schemas (e.g., flat files or sources with varying column counts) without manual reconfiguration.

Key Features

  • Dynamically detects and maps source columns at runtime
  • Reduces package maintenance for variable-width or schema-evolving data sources
  • Designed for seamless integration into existing SSIS data flows

Installation Instructions

  1. Double-click DynamicColumnInstaller.msi to begin installation.
  2. If prompted with a "Publisher Unknown" warning, click More Info and then Run Anyway.
  3. After installation, open SSIS in Visual Studio. You’ll find Dynamic Column Task in the SSIS Toolbox.

Requirements

  • .NET Framework 4.7.2 or later
  • SQL Server Data Tools (SSDT)
  • Visual Studio 2022

Support

For issues or suggestions, contact:
📧 brianclements1@hotmail.com

About

The Dynamic Column Task provides the ability to import flat files with varying column structures into SQL Server tables.

Resources

Stars

Watchers

Forks

Packages

No packages published