I think the account is working since the dbcc command is...

If it runs successfully outside of the job, then we will need more info from the error output of the job. Output all job step history to a text...

The index value is the column position of the recordset you are looping. You want the first column so the index is 0.

What happens when you execute the proc outside of a sql job?

whether you sulk or smile while you stroke

Yes it should

skull

L' Eomot Inversé (8/1/2012)

---

EL Jerry (8/1/2012)

---

Revenant (8/1/2012)

---

crookj (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

Cliff Jones (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

bcsims 90437 (8/1/2012)

---

SQLRNNR (8/1/2012)

---

Cliff Jones (8/1/2012)

---

JAZZ Master (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

Daniel Bowlin (8/1/2012)

---

ChrisM@Work (8/1/2012)

---

opc.three (8/1/2012)

---

New...

This article should help with that

http://bisherryli.wordpress.com/2012/01/27/ssis-107-parameterized-query-in-ole-db-data-source-parameter-information-cannot-be-derived-from-sql-statements-with-sub-select-queries/

Any reasons against using the derived column?

Another simple method is to build a stored procedure that does the select query you need. And then call the stored procedure in...

Unless you have another backup of the files, I don't think you are getting your info back.

I have seen the same thing as Jared. Also have seen it misbehave due to version of .Net.

Neither of those seems to be the case here.

Out of ideas.

This article should help explain what you are experiencing (ownership chaining)

http://www.mssqltips.com/sqlservertip/1782/understanding-cross-database-ownership-chaining-in-sql-server/

balls

Thanks for the question