0

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

public void Main()
        {
            // TODO: Add your code here
            try
            {
                MessageBox.Show("PAckage Starts");
                Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();

                MessageBox.Show("BEFORE ERROR");

                string a=Dts.Variables["System::MachineName"].Value.ToString();
                RunningPackages pkgs = app.GetRunningPackages(null);
               RunningPackages abc = app.GetRunningPackages(a);
                MessageBox.Show("AFTER ERROR");
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
                MessageBox.Show(e.Message.ToString());
            }

            Dts.TaskResult = (int)ScriptResults.Success;
        }

enter image description here

This 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

closed as unclear what you're asking by John Eisbrener, Erik Darling, RDFozz, SqlWorldWide, mustaccio Oct 28 '17 at 14:55

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Please provide more details regarding the package. What is it doing, any code you care to share, etc. – John Eisbrener Oct 27 '17 at 20:36
  • Are you sure MachineName is correct? Note that (from the example in the documentation) it looks like you can provide null instead of a machine name, in which case (I can only assume) it will check the machine the code is running on(?). – RDFozz Oct 27 '17 at 23:39
  • @JohnEisbrener I can easily reproduce the error with the simple code (Updated in my Question) – Jayendran Oct 28 '17 at 5:27
  • @RDFozz I tried with Providing MachineName and also null.Both not working in my case.(See the updated Code in my Question) – Jayendran Oct 28 '17 at 6:17
  • I'm voting to close this question as off-topic because it should be addressed to the vendor's support services. – mustaccio Oct 28 '17 at 14:55
1

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.