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
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
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
41 reads
It's been a while, but since I now get to play with SQL 2016 full time, I have new things...
2016-10-24
707 reads
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 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 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
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
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
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
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
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers