Job creation for a DTS package results in an error - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » Job creation for a DTS package results in an error

Job creation for a DTS package results in an error

Options

Previous Topic · Next Topic

kirun

Posted: Monday, April 07, 2008 12:39:38 AM

Rank: Newbie

Joined: 4/7/2008
Posts: 2
Points: 6
Location: Karachi

I am trying to schedule a SISS package by creating a new job but it is giving me error when the job executes.the error i find when i checked the error log it was the following error

Unable to find index entry in index ID 1, of table 2073058421, in database 'msdb'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. [SQLSTATE HY000] (ConnExecuteCachableOp)

Any help would be appriciated

Scott Whigham

Posted: Tuesday, April 08, 2008 4:01:10 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Have you done what the error tells you to do?

kirun

Posted: Wednesday, April 09, 2008 1:51:55 AM

Rank: Newbie

Joined: 4/7/2008
Posts: 2
Points: 6
Location: Karachi

I figured it out .. i tried and execute this and error was gone

Use msdb
Go
sp_dboption 'msdb', 'single_user', 'true'
GO
DBCC CHECKDB('msdb', REPAIR_REBUILD)

Explaination for dboption single user :
I was getting this error "Msg 7919, Le vel 16, State 3, Line 1 Repair statement not processed. Database needs to be in single user mode." thats why i had to used the single user.

Thanks

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.