Viewing 15 posts - 16 through 30 (of 119 total)
Phil,
This is cool code. I don't really import flat files like I used to but I was curious as to how you would make the fields maintainable (maybe in...
July 25, 2018 at 2:50 pm
One last note.
What you should be doing for notifications for jobs that are mission critical is to:
Create an Operator for the job(s) that you want notifications to go...
July 24, 2018 at 1:24 pm
Set up a test job that will run this sql:
SELECT 1/0
It will fail. Then run the script again to see if the test failed job shows up...
July 24, 2018 at 9:40 am
I wrapped isnull around the query results and it worked fine for me:
DECLARE @tableHTML
July 24, 2018 at 8:35 am
Try this there was an extra /tr after the run date and time
'DECLARE @tableHTML NVARCHAR(MAX) ;
DECLARE @s-2 VARCHAR(max)
SET @s-2 = 'Reconciliation...
July 24, 2018 at 7:56 am
I would trap for nulls they could potentially be the problem as they don't concatenate very well.
July 24, 2018 at 6:53 am
Sorry meant variable:
ADD variable for a Server variable
ADD variable for a Database variable
July 20, 2018 at 1:47 pm
Here is how I do it.
CATALOG
Once the projects are added to the catalog, add the Environments i.e. PROD, TEST
Right click on the packages and select CONFIGURE, SELECT...
July 20, 2018 at 1:45 pm
I got this function off the web a few months ago:
ALTER
July 19, 2018 at 1:45 pm
July 17, 2018 at 1:18 pm
I work for a company that has 20 offices scattered throughout the US/UK. Application performance is HUGE, Security is HUGE and downtime is not an option. Our network team laughs...
July 10, 2018 at 2:15 pm
Click on References then Add your environment variables
May 1, 2018 at 10:55 am
I had to create a powershell proxy account to run ps from sql
April 24, 2018 at 2:23 pm
Jeff wrote:
And please understand that I'm not slamming you. Please consider this to be a peer review with some tips for not only this code, but for...
March 16, 2018 at 6:52 am
which adds unnecessary load...
So, at the cost of keeping it simple and easy to maintain, I'll take it.
Also if the expressions are complex, the expression builder can be...
March 14, 2018 at 11:43 am
Viewing 15 posts - 16 through 30 (of 119 total)