I'm having an issue with a package that contains a script component.
The package was originally designed in SSIS 2005, was migrated to 2008 and not to a 2008 64 bit machine.
We're able to run the package in VS/32 bit mode, but it fails when we deploy the package.
I was able to find a few articles out there, but not clear answer for this issue.
Is it possible to run packages with scripts in 64 bit machines?
The script is pretty simple, it only reads configuration from the machine.config file.
Below is the error message I'm getting:
Executed as user: CITRITE\svcacct_qasqlapps. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:13:22 PM Error: 2010-08-30
16:13:22.70 Code: 0x00000001 Source: Script Task Description: 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 ScriptTask_4b9f5fd6bf8e4c5e99a637abdc7bd178.vbproj.ScriptMain.Main() --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object
target, Object arguments, SignatureStruct&
View Complete Post