SQL Server dumping continuously after running SSIS package

Ovidiu Burlac

SQL Server dumping continuously after running SSIS package

by Ovidiu Burlac » Wed, 03 Feb 2010 04:30:48

My problem is the following:

I've created a SSIS package that will run without any problems in my development environment, but when I move the databases and SSIS packages to another testenvironment it will trigger the SQL Server to dump on every sub-sequent command.

The chain of events:

  1. Create the SSIS package and databases in my development environment.
  2. Run tests wich has no problems.
  3. Move the SSIS package and create backups of the database from my development environment and restore the database in the testenvironment which is in an different AD using an AD-account from that AD.
  4. I run the SSIS package without any problems.
  5. But when I look in the SQL Server logs I can see that the SQL Server is dumping on what I presume is every access. The SQL Server service continue running but won't return any results and the databases are not connectable.

When debugging the problem I think I've located the problem to when I run the following code.

--------------

TRUNCATE TABLE claim
GO

DBCC )
GO

--------------

When I searched the MSDN Forums I found a thread with at problem that seems similiar to mind.
http://www.veryComputer.com/;SiteID=1

Has anyone seen this problem before
If it is the same bug as in the linked thread is there any known Hotfix for this problem

/Fredrik Danielsson



Ovidiu Burlac

SQL Server dumping continuously after running SSIS package

by Ovidiu Burlac » Fri, 05 Feb 2010 05:31:49

Did you try to use the workaround mentioned in the thread you linked

Does it fix the problem for you

Thanks,
Ovidiu



Ovidiu Burlac

SQL Server dumping continuously after running SSIS package

by Ovidiu Burlac » Sat, 06 Feb 2010 07:33:51

Can I get on dump file generated by SQL Server

You can write me at oburlacuFUNNY_AT_SIGNmicrosoftDOTcom

Thanks,
Ovidiu Burlacu




Fredrik Danielsso

SQL Server dumping continuously after running SSIS package

by Fredrik Danielsso » Sun, 07 Feb 2010 06:32:50

I've tried the workaround but it does not work 100%.

/Fredrik

Ovidiu Burlac

SQL Server dumping continuously after running SSIS package

by Ovidiu Burlac » Mon, 08 Feb 2010 08:34:52

Hi Fredrik,

I looked at the crash dump and the crash happens in sqlserver.exe. I'll move the thread to Database Engine so you can get the appropiate help.

Thanks,
Ovidiu Burlacu



Fredrik Danielsso

SQL Server dumping continuously after running SSIS package

by Fredrik Danielsso » Tue, 09 Feb 2010 10:36:54

OK,

Thank you Ovidiu.

Is there anyone in this thread that can help me with these sqlserver.exe crashes

/Fredrik


Ovidiu Burlac

SQL Server dumping continuously after running SSIS package

by Ovidiu Burlac » Wed, 10 Feb 2010 09:35:53

A custome ra hiting a crash in sqlserver.exe, more details can be found here:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=896279&SiteID=1