Please have a look at this MSDN forum post. It references an MSDN article related to SSIS but see the section "Eliminating the "Access Is Denied" Error. The original poster...

If you get this error:

Just delete the "refresh" line (second line) in the script so it looks like this:

Set objSysInfo...

SQLRNNR (6/21/2011)

---

Sumanta Roy (6/21/2011)

---

Hi grant,

As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to SQL...

I gave you a way.

If procA refers to procB and you only compile procA in the database then this query will show you that procA refers to procB:

SELECT ...

Direct replies here: http://www.sqlservercentral.com/Forums/Topic1128842-147-1.aspx

Grant Fritchey (6/21/2011)

---

Sumanta Roy (6/21/2011)

---

Hi grant,

As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to...

Ha! Next time say which file it could not find 😉 Happy you got it sorted 🙂

You're very welcome 🙂

Try converting to DT_WSTR if the max length of your string is 4000 or less. If more then use DT_NTEXT.

b.lam (6/20/2011)

---

@opc.three:

Thanks for the suggestion.

The CTE will actually have to be flipped to include the CONTAINs predicate.

The reason being that the CONTAINs predicate cannot be applied to a table that...

Jeff Moden (6/20/2011)

opc.three (6/20/2011)Having an SSIS package "watch" a directory awaiting the arrival of a file is a trivial task and IMHO should not be a reason to implement xp_cmdshell....

I think the problem is happening with the FTS CONTAINS function.

Here is the parameter list for the TOP 2 query and you can see its using a "map":

Scalar Operator((1)), Scalar...

Two things I would confirm:

> Is your LDAP string is correct? See this post.

> Do you have permission to query that data in Active Directory?

The initial difference I notice is that the TVF in the TOP 1 query is delivering 213,364 rows and the TVF in the TOP 2 query is only delivering 2...

What version is the OS is running on the remote server? What version is the database instance?