Scripting Environments in SSIS
Demo and script on how to script out SSIS Environments and their associated variables
2018-03-02 (first published: 2016-01-21)
20,399 reads
Environments
Best method to drop article from publication?
I have a SQL DTS job that runs every night to populate the FaxList table of a publication with data from our Contact Management database. The job has failed recently because the Identity range is not large enough. The publication automatically gave the article a range of 5000. Currently there are 5010 records in the Contact management […]
2004-09-17
2 reads
RE: How to return a 0 value instead of null
A neat function that I have used is Coalesce. SELECT COALESCE(NULL,0) AS [Result] (where NULL=field of choice)
2004-09-03
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers