SSIS Data Flow "Sequence Containers" are Here!
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,529 reads
SSIS Data Flow "Sequence Containers" are Here!
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
42 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things...
2016-10-24
708 reads
Reading a SharePoint 2007 List from SSIS 2016
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
11 reads
Control Flow Package Parts in SSIS 2016
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,484 reads
Control Flow Package Parts in SSIS 2016
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
136 reads
Consolidating Multiple Data Marts
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
600 reads
Consolidating Multiple Data Marts
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
16 reads
Data Flow Optimization - Collapse Sparse Buffers
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,416 reads
Data Flow Optimization - Collapse Sparse Buffers
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
45 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Split concatenated column data into separate rows
My table1 has a column that has the following in it: (2)Joystick,(3)Candies,(6)Wires I want...
Do same query without (insert into tables or using windows functions)
CREATE TABLE TempA ( InvoiceNo VARCHAR(50) NOT NULL, Date TIMESTAMP NULL, Type VARCHAR(50) NULL,...
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers