The suggestion to remove the article because the author incorrectly identifies the 1000 row limit as being imposed by OPENQUERY and not LDAP is no reason to remove the article....

chrisn-585491 (7/21/2014)

---

In my career I've encountered consultants from company "AC", now renamed company "A", that have driven corporations into the ground with "advice". Their prime skill is the ability to...

Why on earth would anyone want to do this? The scope of a temp table can actually give it a longer life span than a cte which is only...

UNC paths can be tricky sometimes. Since you are using that, has it been set-up as a fileshare? The proxy account will need read write access to the share. ...

Proxies are part of SQL Agent. Did you create a Proxy for SSIS? If so, and you did not have the option to select the Proxy, you've got some permissions...

Yes, that's your next step. Then just run the job.

Please let us know how it turns out.

Almost forgot - if you have not yet had a chance to do so, you should read the excellent Stairway to SQL Sever Agent by Richard Waymire if you're going...

Larry-- I had a similar problem a couple of weeks ago when I was setting up a new developer on a test server. Let's assume for the moment that...