none
error job After got SSIS VB Script be able to refresh existing excel file without human intervention

    Question

  • Hi everyone,

    After got  SSIS VB Script be  able to refresh existing excel file  without human intervention,

    and changed the security level to No encryption.

    My sql server services are:

    Common Name

    State

    Log on

    SQL Server

    Running

    Domain\My_user

    SQL Server Agent

    Running

    Domain\My_user

    SQL Server Analysis Services

    Running

    Domain\My_user

    SQL Server Browser

    Stop

    NT_autorithy\local_Server

    SQL Server Full Text Search

    Running

    NT_autorithy\local_Server

    SQL Server Integration Services

    Running

    Domain\My_user

    SQL Server Reporting Services

    Running

    NT_autorithy\networkservices

     

     I Still NOT be able to get work in JOB.

    What could be the issue?

    message:

    -------------------Start error message

    Executed as user: domain\my_user. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.4000.0 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  5:45:54 PM  Error: 2013-01-25 17:45:56.11     Code: 0x00000001     Source: Script Task      Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file '\\computer_name\test\test.xlsm'. There are several possible reasons:   

    ? The file name or path does not exist. 

    ? The file is being used by another program

    ? The workbook you are trying to save has the same name as a currently open workbook.    

    at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)    

    at ST_6ff4b1e36fef45a5b3d3f0c9e3b0c825.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.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 Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()  End Error  DTExec: The package execution returned DTSER_FAILURE (1). 

    Started:  5:45:54 PM  Finished: 5:45:56 PM  Elapsed:  1.498 seconds.  The package execution failed.  The step failed.

    -------------------End error message

    fails in SQL Agent Job (works when executed from BIDS)!!!

     I tested on the server itself, or on my machine for development and I get the same thing

    Thanks in advance!!




    cris


    • Edited by perezco Saturday, January 26, 2013 3:28 AM adding details
    Friday, January 25, 2013 11:06 PM

Answers

All replies