Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue with custom SSIS powershell task Expand / Collapse
Author
Message
Posted Thursday, March 7, 2013 10:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 1:23 PM
Points: 18, Visits: 144
I have SSIS task calling custom powershell task and the package works when manually ran in BIDS. But when I call the package with SQL Agent as a scheduled job it complete in like 30 secs and it completes with successful reporting. It should take much longer; in BIDS like 15 mins. The powershell is not doing it's task with the SQL Agent. It's like it doesn't have enough time.

I have set the SQL Agent Service to run as myself to clear any security issues.
I have also setup a proxy account to run as myself but get the same results.

When I run it from server's MSDB it works correctly. It just seems to be the SQL Agent process.

This my SSIS package and powershell script. http://www.red-gate.com/messageboard/viewtopic.php?t=16405

SSIS Powershell task: http://powershellscripttask.codeplex.com/ and http://ssisctc.codeplex.com/
Post #1428112
Posted Thursday, March 7, 2013 12:58 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:52 PM
Points: 7,079, Visits: 12,569
It could be a permissions issue. Anything in the Agent Job logs?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1428216
Posted Friday, March 8, 2013 6:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 1:23 PM
Points: 18, Visits: 144
I found this in the log.

Date		3/8/2013 8:16:52 AM
Log Windows NT (Red Gate Software)

Source SQL Doc 2
Category (0)
Event 32
Computer MYPC

Message
CommandLine
Main:Unhandled Exception
System.ArgumentNullException: Value cannot be null.
Parameter name: value
at System.IO.Directory.SetCurrentDirectory(String path)
at System.Environment.set_CurrentDirectory(String value)
at RedGate.SQLDoc.Engine.Project.Project.(String )
at RedGate.SQLDoc.Engine.Project.Project.set_FilePathOfHtml(String value)
at RedGate.SQLDoc.Engine.Project.Project..ctor()
at RedGate.SQLDoc.Engine.Project.Project.LoadFromDisk(String pathAndFileName)
at RedGate.SQLDoc.UI.CommandProcessor.RunProject()
at RedGate.SQLDoc.UI.CommandProcessor.Run()
at RedGate.SQLDoc.UI.Program.Main(String[] args)

Post #1428550
Posted Friday, March 8, 2013 7:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:52 PM
Points: 7,079, Visits: 12,569
That's an error from SQL Doc and would not be related to this.

Try looking in the Agent Job History log. Right-click the job and select View History.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1428568
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse