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,784 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,844 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,063 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,603 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,270 reads

All authors

Blogs

My Social Media Rules

By Brian Kelley

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By Steve Jones

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Subang Telp:08218154374

By layanan_Bca88

Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...

Alamat Kantor BCA KCU Purwakarta Telp:08218154374

By m4rt1n4

Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...

Alamat BCA KCU Soekarno Hatta Telp:08218154374

By R4nt4u

Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...

Visit the forum

Question of the Day

I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):

orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1

SELECT * from dbo.OrderHeader where customerid between 3 and '6'

See possible answers