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,698 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,829 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,008 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,584 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

27,929 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

Reverse Engineering a Physical Model Diagram

Prepping for Certification, Part 3 of ?

SQL Training Black Friday Deals

Forums

Best analysis approach to reduce data type length in multiple tables

Do you separate data/log files and TempDB files on different disks using AWS EC2

Service account being in local admin in AWS EC2 environment?

Question of the Day

A New Operator