locked
SQL server 2008 - Exception Error RRS feed

  • Question

  • Hi,

    I am running SSIS package as a Job from SQL server agent. SSIS package is running under proxy a/c, obviously proxy got admin rights both on domain and on SQL server. 

    Package job is to create folder and read it from there. But some reason its throwing me exception error.

     

    Log Job History (FoodworksPDF)

     

    Step ID 1

    Server FW-SQL01

    Job Name FoodworksPDF

    Step Name FoodworksPDF

    Duration 00:00:01

    Sql Severity 0

    Sql Message ID 0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted 0

     

    Message

    Executed as user: AUR\fdev. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  2:31:20 PM  Error: 2011-07-21 14:31:21.61     Code: 0x00000001     Source: Create Dir (New)      Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Exception: Source directory: I:\Marketing\Website PDFs\2011-07-18, does not exist - Aborting     at ST_6f2a77f3ed5341ae987da7f3fd5bbc67.vbproj.ScriptMain.Main()     --- End of inner exception stack trace ---     at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)     at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)     at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)     at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)     at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  2:31:20 PM  Finished: 2:31:21 PM  Elapsed:  1.046 seconds.  The package execution failed.  The step failed.

     

     

    Need some help in this.

     

    Thanks,

     

     

     

    Thursday, July 21, 2011 5:18 AM

All replies

  • >>>Source directory: I:\Marketing\Website PDFs\2011-07-18, does not exist -
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by retracementMVP Sunday, August 14, 2011 6:40 PM
    Thursday, July 21, 2011 7:58 AM