As I said, no explicit permissions. The user...

Phil Parkin (11/18/2016)

---

planetmatt (11/18/2016)

---

Phil Parkin (11/18/2016)

---

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no...

Phil Parkin (11/18/2016)

---

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test', 'U')...

Another weird thing to throw in the mix.

When examining the raw data in SQL, SELECTing the row in question with a SELECT * does not show the "?". Only...

Phil Parkin (11/18/2016)

---

planetmatt (11/18/2016)

---

I have a simple package that takes data from a SPROC and puts it in a .CSV file.

Until today, it ran without issue.

The error it's now throwing...

Is this account separate from the one used as the SQL Agent Service "Log On As" Account?

So you have one Windows Account, One Credential,and One Proxy.

This account then has read/write on any external file locations as needed by any SSIS package.

Is this Windows account then used...

Jez-448386 (5/5/2016)

---

Personally, I think this is overkill. Usually I have a single service account to run all SQL Agent jobs and ensure that job has appropriate permissions.

If you are...

WHERE Item like '%[S,B]'

Bill Talada (4/29/2015)

---

I suspect you had a nested transaction. If you tried to test the script by stopping it, you may have created a nested transaction the second time...

There are 737million rows total. I need to delete all records related to a master...

Clever stuff, might give that a try. Comments about performance taken on board. Thanks chaps.

I had already considered using SSIS to move the smaller table to the other server and then performing the cross join in a OLEDB Source component. While this would...

My...

MANU (10/6/2008)

---

Have you checked the default log file location where these files get created? Also, run select * from sys.traces and see under the path dispalyed in output of above...