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

2,560 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

3,722 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

3,234 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,147 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

24,359 reads