Custom Handling Flat File Output of an SSIS Package with the Script Component
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,803 reads
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,803 reads
Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...
2014-11-11
4,852 reads
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,073 reads
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,612 reads
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,321 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers