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,746 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,834 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,031 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,590 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,104 reads

All authors

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

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

Changing the Cardinality of a FK in Redgate Data Modeler

Forums

Removing TDE

Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Question of the Day

Removing TDE