Viewing 15 posts - 4,216 through 4,230 (of 9,715 total)
I don't know how you can add an entire job history, but you can check the success / failure of a job and its individual steps by querying against sysjobs,...
July 6, 2012 at 12:09 pm
You may have to make the query dynamic SQL (stored in a variable) and execute the variable in order to get the Body = @tableHTML part of it working correctly.
July 6, 2012 at 12:07 pm
bitbucket-25253 (7/6/2012)
I would suggest reading Jeff Moden's aticle here on SSC at:http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D
Making it a clickable link. @=)
July 6, 2012 at 12:00 pm
tim.cloud (7/6/2012)
I need one that will always display the last day of the fiscal year.
What is your fiscal year? And do you keep track of it in other ways in...
July 6, 2012 at 11:57 am
I've never run into an instance where using CAST over CONVERT (or vice versa) has made a difference in code performance. The problem is usually related to the rest of...
July 6, 2012 at 10:49 am
OCTom (7/6/2012)
Brandie Tarvin (7/6/2012)
July 6, 2012 at 6:36 am
Another recommendation:
Learn the data, learn the business.
If you know the data well enough to recognize bad data the instant you see it on a report or in an administrative request,...
July 6, 2012 at 6:24 am
One thing I strongly advise: Do not take this career path just for the possibility of high pay. If you do not like what you are doing, then the pay...
July 6, 2012 at 6:19 am
Before removing any indexes from a production system, it is a wise idea to try removing them from a QA environment and running full-load tests to see if it in...
July 6, 2012 at 6:16 am
You cannot use the keyword IN on the "result" side of a CASE statement, only on the conditional side of the statement.
CASE means "please check"
WHEN means "these conditions"
THEN means "this...
July 6, 2012 at 6:09 am
So you see more clearly what I'm working with, I've attached a snapshot of my SSIS package with a few sensitive things blurred out.
The job runs and sends one to...
July 6, 2012 at 5:58 am
Brandie Tarvin (7/6/2012)
Koen Verbeeck (6/8/2012)
Enable logging on preexecute on postexecute events, so you can exactly see what is going on.I think I shall do just that. Thanks, Koen.
Hmm. Except it...
July 6, 2012 at 5:48 am
Koen Verbeeck (6/8/2012)
Enable logging on preexecute on postexecute events, so you can exactly see what is going on.
I think I shall do just that. Thanks, Koen.
July 6, 2012 at 5:40 am
andersg98 (6/7/2012)
Is the entire dataflow configured inside a Sequence container?
No. It's configured in the ForEach container.
July 6, 2012 at 5:40 am
Viewing 15 posts - 4,216 through 4,230 (of 9,715 total)