Those are some excellent ideas and certainly food for thought. I'll give that a go and report my findings here.

I've got a similar issue where something works well in VS2008 but not at all in SSRS once it's deployed.

If I get any update I'll post here if you do...

Just a quick update to advise that un-installing 11g and installing 10g driver resolved this issue.

I think the question is: is there a way to populate a User::variable from an expression, eg. SET [User::variablename]='value' so that any subsequent expressions or SSIS tasks can read this...

I do have sysadmin role assigned to my user, I just created the entire database, created four other dimension tables and now I want to use the Generate Schema Wizard...

You could create a Dataset called ReportTitle which queries a DB for the Report names but you'd need to include a reference of some kind in the DS query and...

This jiggery-pokery on the data worked a treat and cured the problem. I couldn't see any strange formatting or spaces in the data but obviously there is some! Thanks again...

I'll give that a go, thanks for your reply. What's strange is that when I run the query manually on the database (ie. not through the report) there is no...

Here's the cmdline I ran since your reply but I can't get it working:

RUNAS /user:<ourdomain>\<myuseracct> C:\Windows\System32\Robocopy.exe c:\Backup\ \\<servername>\<repositorypath>\ /E /z /MOV /NP >> .\ROBCOPY_LOG.TXT

I now seriously think this is actually...

Just tried that now. Opened a command-prompt; CD <scriptdir>

c:\Scripts>C:\Windows\System32\Robocopy.exe c:\Backup\ \\<servername>\<repositorypath>\ /E /z /MOV /NP >> .\ROBCOPY_LOG.TXT

and nada.

The log file (.\ROBCOPY_LOG.txt) did not populate BUT the Output file...

Thanks but I've already advised the output file returns nothing: "nothing is written to the SQL Agent job Output File for that step." (because the job completes successfully).

With regards to...

I'll try running the CMD line as a one-liner in command prompt and see if that makes any difference.

The script is a batch script which as I say runs fine...

Robocopy isn't freeware, it now comes packed with Windows (it was a separate download previously). Also, when I log in as any user (SQL Agent or myself) and I double-click...

In Addition, I created a proxy which uses my own personal local admin credentials and selected that proxy for this job step. Unfortunately the same thing happens.

CLS

REM - SCRIPT TO MOVE BACKUPS FROM C:\Backup\ directory to \\<server>\SUK01SQL01_Backups\ path.

REM

REM ---blurb---

REM

REM

SET LOGFILE=.\ROBCOPY_LOG.TXT

SET SOURCE=c:\BackupSET DESTINATION=\\<source_server>\S<dest_server>_BACKUPS

ECHO %DATE%-%TIME% Robocopy Began > %LOGFILE%

ECHO >> %LOGFILE%

C:\Windows\System32\Robocopy.exe %SOURCE% %DESTINATION% /E /z /MOV /NP >>...