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
631 reads
Josef Richberg
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
213 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
13 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
12 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
693 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
3 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
478 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
2 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
6 reads
On Being the 2009 Exceptional DBA
A guest editorial from Josef Richberg, winner of the Exceptional DBA contests in 2009.
2010-06-30
256 reads
Blogs
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers