SSIS: Using a Script Component as a substitute OLEDB Destination
I developed an SSIS package that loads invoices, statements, pro-formas, etc. into a SQL Server table. The invoices are .pdf...
2010-11-05
633 reads
SQLRunner
SSIS: Using a Script Component as a substitute OLEDB Destination
I developed an SSIS package that loads invoices, statements, pro-formas,
etc. into a SQL Server table. The invoices are .pdf files and the business
required that no identical documents...
2010-11-05
221 reads
SSIS: Using a Script Component as a substitute OLEDB Destination
I developed an SSIS package that loads invoices, statements, pro-formas, etc. into a SQL Server table. The invoices are .pdf files and the business required that no identical documents...
2010-11-05
15 reads
A local SSIS queue in C#; because the muffins are that good.
Since I designed the Enhanced Threading Framework (ETF) I am always looking to improve it. Status quo is not for...
2010-07-17
695 reads
A local SSIS queue in C#; because the muffins are that good.
Since I designed the Enhanced Threading Framework (ETF) I am always looking
to improve it. Status quo is not for me. I decided to take on the 'queue'
part...
2010-07-17
16 reads
A local SSIS queue in C#; because the muffins are that good.
Since I designed the Enhanced Threading Framework (ETF) I am always looking to improve it. Status quo is not for me. I decided to take on the 'queue' part...
2010-07-17
7 reads
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use...
2010-07-06
480 reads
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use with my Enhanced Threading Framework. This has been challenging...
2010-07-06
4 reads
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use with my Enhanced Threading Framework. This has been challenging...
2010-07-06
9 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...
2010-05-28
16 reads
Blogs
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers