Thanks Resender.

I've included the script that one of the guys passed to be as well. I have a feeling he found it only, but there's no annotations to say where...

happycat59 (10/7/2015)

---

Try updating the connection string to include "IMEX=1" - this should tell the OLEDB provider to treat all cells as text. FOr more info - see

Apparently SSIS, and my PC needed a restart. I shutdown at the end of the day last night, and booted up this morning, to find it quite happy to find...

32bit. i have a feeling that the error for running...

None of them are hidden.

I got around this in the end, by setting the task to run in as an Agent Job. This isn't really the solution I wanted, as it's now on a...

What does the execution log tell you? It'll give both the taskthat the error occured on, and the error that was returned.

To view the log, expand the Integration Services Catalogs...

I'm defining the full address, with the server name, and directors, rather than the shared directory name.

I'm already running SSMS...

Jack Corbett (5/22/2015)

---

When running in SSMS I believe it is running under the SQL Server Service account. I know it is not running under the SQL Agent...

There's not on Standard, no.

I execute a stored procedure prior to the RS Execution, which another one of the DBAs we have made, which is as follows:

Create Proc [dbo].[UpdateRSOutputFile_sp]...

That's great, thanks.

Having a further fiddle with your code, showed me that the literal string after the then is always returned as a varchar, regardless as to what the variable...