Todd McDermid's Blog

SSIS Data Flow "Sequence Containers" are Here!

• by Todd-McDermid

• Todd McDermid's Blog

Wooo!OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline.  However, I just stumbled across a feature in SSIS that I...

2016-12-01

3 reads

SSIS Data Flow "Sequence Containers" are Here!

• by Todd-McDermid

• Todd McDermid's Blog

Wooo!
OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline.  However, I just...

2016-12-08 (first published: 2016-12-01)

1,517 reads

Reading a SharePoint 2007 List from SSIS 2016

• by Todd-McDermid

• Todd McDermid's Blog

It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about!  One of major difficulties that any technology...

2016-10-24

2 reads

Reading a SharePoint 2007 List from SSIS 2016

• by Todd-McDermid

• Todd McDermid's Blog

It's been a while, but since I now get to play with SQL 2016 full time, I have new things...

2016-10-24

613 reads

Control Flow Package Parts in SSIS 2016

• by Todd-McDermid

• Todd McDermid's Blog

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages.  The intent is great, but like...

2016-10-14

15 reads

Control Flow Package Parts in SSIS 2016

• by Todd-McDermid

• Todd McDermid's Blog

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...

2016-10-20 (first published: 2016-10-14)

3,352 reads

Consolidating Multiple Data Marts

• by Todd-McDermid

• Todd McDermid's Blog

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering.  The BI group at CHC used to assign specific...

2015-08-03

2 reads

Consolidating Multiple Data Marts

• by Todd-McDermid

• Todd McDermid's Blog

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. ...

2015-08-03

593 reads

Data Flow Optimization - Collapse Sparse Buffers

• by Todd-McDermid

• Todd McDermid's Blog

I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT a "try this for all data flow performance...

2012-10-22

2 reads

Data Flow Optimization - Collapse Sparse Buffers

• by Todd-McDermid

• Todd McDermid's Blog

I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT...

2012-10-22

1,408 reads