Hi,
I am trying to use SSIS to pull batch information and eventually transaction information for an accounting report. I am trying to take code from the Sample project and implement it using SQL Server integration Services. I am trying to get the routine "GetSettledBatchList" implemented as a Script Task within SSIS. At one point I thought I had the Authorize.Net logic working, so I attempted to add a Stored Procedure within the code to capture the transaction data and write it to the database. My initial attempt adding the stored procedure yielded the error "Exception has been thrown by the target of an invocation", so I eventually wrote a Script Task to just execute the stored procedure sending hard coded data and i was able to get that to work. I went back to trying to implement the GetSettledBatchList logic in SSIS and received the same error message. I have tried working with VS 2010, 2012 and 2013 and I have worked on two different PCs, all throwing the same exception (trying to rule out issues with the Authorize.Net DLL). I was able to modify the original .NET code from the Sample Project to write the data to the database without any problems - it is just moving the logic to SSIS that I am having problems with. I have even removed almost all of the Authorize.Net code from the Script Task and just executed the statement to set the environment variable - with no luck.
I am hoping someone can give me some clues as to what is causing the issue in SSIS. I didn't see any examples of working with SSIS online.
The error displays in a "DTS Script Task: Runtime Error" window.
The error message is:
Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
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()
Here is the code throwing the error if it helps:
#region Namespaces
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using AuthorizeNet;
using AuthorizeNet.Api.Controllers;
using AuthorizeNet.Api.Contracts.V1;
using AuthorizeNet.Api.Controllers.Bases;
using System.Data.SqlClient;
#endregion
namespace ST_acecc688c00942cd86176e2d724b96fb
{
[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{
public void Main()
{
String ApiLoginID = Dts.Variables["User::APILoginID"].Value.ToString();
String ApiTransactionKey = Dts.Variables["User::APITranKey"].Value.ToString();
Console.WriteLine("Get settled batch list sample");
ApiOperationBase<ANetApiRequest, ANetApiResponse>.RunEnvironment = AuthorizeNet.Environment.SANDBOX;
Dts.TaskResult = (int)ScriptResults.Success;
}
Any assistance will be appreciated.
Thanks!
