Viewing 15 posts - 1 through 15 (of 112 total)
Brilliant!!
SELECT j.name, h.message, h.run_date, h.run_time, h.step_name
FROM sysjobs j
INNER JOIN sysjobhistory h
ON j.job_id = h.job_id
where h.step_name = '(Job outcome)'
AND msdb.dbo.agent_datetime(h.run_date,h.run_time) > (GETDATE() - 1)
is MUCH cleaner and...
March 24, 2014 at 3:40 pm
If I remember correctly, your MSAccess error is telling you that it can't find a wizard. to get the import/export wizard you have to "install advanced features" when installing Access....
March 10, 2014 at 9:17 am
Hi -
you might want to check out the free "File Watcher" Task @
I have not used it myself but it is used in several of...
January 28, 2014 at 4:21 pm
ah, yes. The first time I encountered the hex encoded delimiters it drove me NUTS!! I guess it has something to do with the way the dtsx file is...
October 4, 2013 at 4:43 pm
Thank you for the explanations and examples!! This "easy" problem has caused much frustration.
September 20, 2013 at 4:16 pm
hello all again - I didn't want to bail out without showing my appreciation for the help on this forum. I got a new "top priorty" when I got in...
September 19, 2013 at 1:06 pm
hey -
I'm by no means one of the gurus on this site, but whenever I've run into this it's been permissions issues. Make sure the account that SQL...
July 25, 2013 at 2:41 pm
One caution I want to throw out here - environment variables are NOT instance aware. That is if you have 2 (or more) instances of SQL Server on the same...
May 15, 2013 at 9:57 am
I agree - check the job history detail for that step. SQL server is actually pretty good at putting useful messaging in there.
Gonna go out on a limb here,...
February 13, 2013 at 10:14 am
I enjoyed the session in Austin this year. I hope you're planning on coming again. I could see that there was a ton of time and effort put into it!
BTW...
November 9, 2012 at 11:47 am
Did you hastily re-type that (I doubt it) or did they seriously send that as is? The posting has many redundancies, misspellings, grammatical errors and seems to bounce all over...
November 7, 2012 at 4:36 pm
I use a program called "CutePDF". you can google for it and find the download site. It installs as a printer driver. All you have to do is "print"...
October 4, 2012 at 9:31 am
After seeing the picture, all I can think of is "Damn, pulling that tape off musta hurt!"
August 29, 2012 at 9:14 am
hey all -
something I ran into just recently when working on a package that uses an environment variable to config from (maybe everyone else knows this already)....
July 10, 2012 at 3:30 pm
Hey my friend opc.three!
Just before you replied the lightbulb over my head fired off. I noticed in the output from the package the FEL throws a warning message...
May 25, 2012 at 10:56 am
Viewing 15 posts - 1 through 15 (of 112 total)