Script Task working in Visual Studio but not when the package is run by a job?

I have a script that changes the name of a file after a data upload. The script works fine if I execute the package in Visual Studio but when I run the file package from a SQL server job it does not rename the file. The data does get uploaded it just does not run the final script.

Any help would be appreciated.

Steve

Have you enabled logging to get the error?

The problems when running under Agent are mostly related to authentication and permissions issues - as the job probably runs under different credentials compared to interactive execution. Your options are either configure job to run under your account, or fix the permissions to allow job account to perform the operation that is failing.

See this KB for troubleshooting steps:
http://support.microsoft.com/kb/918760

Script for Posting RDLs

Hi there,
There are times when i post up to 100 rdls on to the report server. But this
process is long drawn as you can only upload 1 file at a time from the
reportserver.
I've heard of people here talking of a script to deploy reports which makes
it a hell of alot quicker than uploading manually.
Firstly, what is the script, and secondly where do you execute it(is it on
the same platform as where Reports are coded?)
Thanks in Advance
SanjeevHi Sanjeev,
Use the rs.exe command line utility
see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8l42.asp
see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_61gi.asp
regards,
- peteZ
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:%23yCjXMQsEHA.2788@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> There are times when i post up to 100 rdls on to the report server. But
> this process is long drawn as you can only upload 1 file at a time from
> the reportserver.
> I've heard of people here talking of a script to deploy reports which
> makes it a hell of alot quicker than uploading manually.
> Firstly, what is the script, and secondly where do you execute it(is it on
> the same platform as where Reports are coded?)
> Thanks in Advance
> Sanjeev
>|||Hi,
I am getting somewhere now.
But i am still experiencing a problem. When i run the command to publish my
RDLs it says that the corresponding *.rss script cannot be found. Do you
know how to install these .rss scripts onto the hard-drive.
Sorry for bugging
Thanks PeteZ
Sanjeev
"PeteZ" <peteZ@.aol.com> wrote in message
news:e0OAiVQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> Hi Sanjeev,
> Use the rs.exe command line utility
> see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8l42.asp
> see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_61gi.asp
> regards,
> - peteZ
>
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:%23yCjXMQsEHA.2788@.TK2MSFTNGP09.phx.gbl...
>> Hi there,
>> There are times when i post up to 100 rdls on to the report server. But
>> this process is long drawn as you can only upload 1 file at a time from
>> the reportserver.
>> I've heard of people here talking of a script to deploy reports which
>> makes it a hell of alot quicker than uploading manually.
>> Firstly, what is the script, and secondly where do you execute it(is it
>> on the same platform as where Reports are coded?)
>> Thanks in Advance
>> Sanjeev
>