SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SSIS 2008 error System.NullReferenceException: Obj
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Viron26
Starting Member

1 Posts

Posted - 02/21/2013 :  08:31:11  Show Profile  Reply with Quote
Hello everyone,

I have set upt a package on SSIS 2008 with a vb script that runs an excel macro. It works on vs 2008 but still I get the following error:

Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at ST_e916156b0e6449b58e21905bd635ecf0.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()

Also when I run the package with SQL agent, the job is successful howver the macro is not executed and I get the following error:
Message
Executed as user: 'myusername'. Code: 0xFFFFFFFF Source: Run macro script excel macro Description: Microsoft Excel cannot access the file 'book1.XLS'. 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. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 11:18:15 Finished: 11:18:19 Elapsed: 3.775 seconds. The package executed successfully. The step succeeded.

However, I have full access to the local server and network and I have tried to run on both 32 bit and 64 bit but no success.

Can anyone help please?

Thanks a lot
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000