Thanks Lowell, that does more than we need but it is a good starting off place, not so much craptastic at all!.  I also had the idea to let the...

VastSQL, thanks but they already are in SQLAgentOperator. The problem is that they cannot change the job owner to the service account.
John MItchell: This looks like maybe what we...

OK thanks, so far I see 2008>>2012 it works, 2012>>2014 it works. This is very encouraging news, indeed. Anyone done 2008>>2014?

Agreed this is not an "AlwaysOn" specific problem. We have been using a modified version of sp_help_revlogin from this https://support.microsoft.com/en-us/kb/918992, but we are about to embark upon...

Groovy. The Microsoft team took the fix down. Dead link.

sorry this does not do what it is advertised. I'm looking for something very simple (one would think) that returns 1 if job is running RIGHT NOW, 0 if not....

Thanks! That was a quick easy solution. I love this site.

Looking forward to the rest of the series, Andy. Thanks for your time and effort. Alas, I don't tweet but I do check back here very often. It would be...

Yup, thanks GSquared. NullIf explanation saved me today.

Hey, thanks for the article. Very inclusive and detailed! For a quick reference, I've used this site for years (it is easy to remember): http://connectionstrings.com/[/url]

Nevermind. Answered my own question.

Solution Details:

1. Looking for a file with yesterday's date in the file name

2. pattern is "fileName_" + ddmmyy + <ten random chars> + .csv

3. Path is...

OK so I set up the foreach loop and put the (file >> table) data flow task in it. It is not finding the file using the path expresssion in...

Thanks for the quick reply, John. I"m trying to figure out how you mean.

In the ForEach Loop, would I use a ForEachFileEnumerator? How do I get the collection of files...

Hey Steve, thanks for updating your list. Microsoft doesn't seem to support the old URLs any more, so you've got some broken links/

eg http://support.microsoft.com/?kbid=932557 works, but

Hey Jay,

When you say install oracle client on the share drive are you talking about the "quorum"?