title: "Runtime error Exception has been thrown by the target of an invocation" from Script task
body: <p>I have a SSIS package with a script task, I get the following error when i try to run it in my local system. It works fine for my collegues as well as in production. However, I am not able to run it locally, to test. I keep a debug point in the main method, but it is never reached, I get the error before it goes to main method.</p>
  
  <p><img src="https://i.stack.imgur.com/BSXTy.png" alt="enter image description here"></p>
  
  <p>I am using VS 2010, .Net framework 4.5.</p>
  
  <p>The script task does compile. I get the following messages SSIS package "..\Test.dtsx" starting. Error: 0x1 at Test: Exception has been thrown by the target of an invocation. Task failed: Test SSIS package "..\Test.dtsx" finished: Success. The program '[2552] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).</p>
  
  <p>The following is the code:</p>
  
  <pre><code>public void Main()
  {
  try
  {
   LogMessages("Update Bug package execution started at :: " + DateTime.Now.ToLongTimeString());
   LogMessages("Loading package configuration values to local variables.");
  
  strDBConn = Dts.Variables["User::DBConnection"] != null ? Dts.Variables["User::DBConnection"].Value.ToString() : string.Empty;
  strTPCUrl = Dts.Variables["User::TPCUrl"] != null ? Dts.Variables["User::TPCUrl"].Value.ToString() : string.Empty;
  
  TfsTeamProjectCollection objTPC = new TfsTeamProjectCollection(new Uri(strTPCUrl));
  WorkItemStore objWIS = new WorkItemStore(objTPC);
  WorkItemCollection objWIC = objWIS.Query("SELECT...");
  
  foreach (WorkItem wi in objWIC)
  {
  }
  
  }
  catch(Exception ex)
  {
  }
  </code></pre>
  
  <p>When I commented the code from TfsTeamProjectCollection objTPC = new TfsTeamProjectCollection(new Uri(strTPCUrl)); The script executes successfully. However, if i keep TfsTeamProjectCollection objTPC = new TfsTeamProjectCollection(new Uri(strTPCUrl)); and comment the rest, i get the exception.
  I do have access to the URL.</p>
  
  <p>I am using Microsoft.TeamFoundation.Client.dll and Microsoft.TeamFoundation.WorkItemTracking.Client.dll, in my script task. However the dll version in the package is 10.0, and the version of the dll in my GAC is 12.0. Would that cause a problem?</p>