Arithmetic Overflow at RunningPackages problem

• jayendranarumugam

  SSC Veteran

  Points: 264

  More actions

  October 27, 2017 at 9:37 am

  #340992

  Hi all,

  I've developed a SSIS Package with the C# Code.All the Package were running fine.But for the past 2 days we are experiencing 

  Application ssisApplication = new Microsoft.SqlServer.Dts.Runtime.Application();
  string thisPackgeName = Dts.Variables["PackageName"].Value.ToString();
  RunningPackages Pkgs = ssisApplication.GetRunningPackages(MachineName);

  

  Above is my Stack Trace.
  I've already browsed regarding this issue but not getting any solution. Some Reference here.

  Investigating into this with Process Monitor tool. The Issue is coming from MsDtsSrvr.dll (C:\Program Files (x86)\Microsoft SQL Server\DTS\Binn\MsDtsSrvr.dll)

  Arithmetic operation resulted in an overflow. (MsDtsSrvr)

  Unfortunately, this Issue is not happening in other Environments.

  Anybody, please guide me to solve this error

  Thanks in advance,
  Jay

• jayendranarumugam

  SSC Veteran

  Points: 264

  More actions

  October 28, 2017 at 4:09 am

  #1965652

  I've found the solution.As I've told already this is related to MsDtsSrvr.dll

  So, I've just Restarted the MsDtsServer110 Service.

  No it works Perfectly