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,088 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,088 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,520 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
3,663 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,403 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
26,494 reads
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
Hello, I need help to improve an existing (hence I cannot change table's structure...
In Brent Ozar's list of links today, I learned that Microsoft has removed the...