Chim Kalunta is a Database Systems Developer and Independent Consultant working out of the UK.
An MCITP: Database Developer and an MCITP: Database Administrator, he can be reached at chimkalunta.com.

Custom Handling Flat File Output of an SSIS Package with the Script Component

by CKX

On the Fringe

I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...

2017-04-02

3,736 reads

Consuming the Output of an SSIS Package in a Client Application

by CKX

On the Fringe

Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...

2014-11-11

4,833 reads

Index Scripting with Powershell

by CKX

On the Fringe

I’ve been actively seeking out opportunities to do more stuff with Powershell of late.
I had wanted to script out only...

2014-03-21

4,026 reads

Doing it with the EzAPI

by CKX

On the Fringe

In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...

2014-03-09

4,589 reads

Creating and Executing an SSIS Package Programmatically

by CKX

On the Fringe

One of the nice things about SQL Server Integration Services (SSIS) is its extensibility.
If you find you have need for...

2013-08-25

28,059 reads

All authors

Blogs

Read the latest Blogs

Custom Handling Flat File Output of an SSIS Package with the Script Component

Consuming the Output of an SSIS Package in a Client Application

Index Scripting with Powershell

Doing it with the EzAPI

Creating and Executing an SSIS Package Programmatically

Blogs

“We love to debate minutiae”

Advice I Like: Knots

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

Forums

Windows logins for users migrated from DomainA to DomainB

Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Question of the Day

Upgrading Admin Queries