Re: SQL Server Agent Job vs Stored Packages

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello OysteinNorway@xxxxxxxxxxxxxxxxxxxxxxxxx,


Quick question.

When you execute a package as a job , how do you see the tasks turn yellow?

Could you also tell us what the Script Task actually Does?


Allan

Hi!
I got a package with a Script task(VB) that runs OK when executing
under
Stored Packages, File system but fails(stays "yellow") under SQL
server Agent
Jobs. I've secured the package with "EncryptAllWithPassword". I guess
it
might be a security issue in Sql server agent. Anyone know how to fix
this.
Thanks,

Oystein



.

Relevant Pages

  • Re: Using Python in ActiveX task - works when run as separate step
    ... I just used some simple script to test: ... I installed ActivePerl on my test machine, create a new DTS package, and a ... new ActiveX script task. ... |>>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • Re: ActiveX script works in DTS but not in job, why?
    ... When you execute the package, are you logged in as the same user under which ... and run the DTS package? ... Peter DeBetta, MVP - SQL Server ... The script works just great ...
    (microsoft.public.sqlserver.dts)
  • Script Controlled Dynamic Task Execution
    ... Transformation Tasks into my SQL Server database. ... need to execute one transformation on a text file, ... I have a script that wants to take complete control of the ... Package as far as source connections and task executions, ...
    (microsoft.public.sqlserver.dts)
  • Re: Script Controlled Dynamic Task Execution
    ... > Transformation Tasks into my SQL Server database. ... > need to execute one transformation on a text file, ... I have a script that wants to take complete control of the ... > Package as far as source connections and task executions, ...
    (microsoft.public.sqlserver.dts)
  • Nested packages not firing events when executed via .NET interop
    ... This works fine on individual packages, but when I execute a package ... void PackageEvents.OnError(string EventSource, int ErrorCode, ...
    (microsoft.public.sqlserver.dts)