Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Blocking on server when running package Expand / Collapse
Author
Message
Posted Monday, March 16, 2009 7:27 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 7:46 AM
Points: 533, Visits: 990
I have 2 packages package1 and package2. package2 contains 3 Data Flow Tasks.
When I execute the package2 from BIDS, it completes successfully; but when I execute package2 from package1 (using Execute Package task) from BIDS I get blocking on the SQL server.

The reason why I am getting mad is that my process is getting blocked by SPID -2(minus2).
I have never seen any SPID with negative value. What is this process?

My process is executing the following command:
exec [sys].sp_bcp_dbcmptlevel [DBNAME] 
set fmtonly on
select * from [dbo].[TableName]
set fmtonly off

Looks like SSIS is getting the metadata from the server but it is getting blocked.

Can anyone help me?


-Vikas Bindra
Post #676467
Posted Monday, March 16, 2009 12:00 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 7:46 AM
Points: 533, Visits: 990
I figured out that SPID -2 is some kind of SQL server process and is visible in Activity monitor.

But, why is it blocking my process?


-Vikas Bindra
Post #676804
Posted Thursday, August 02, 2012 11:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 06, 2012 9:31 AM
Points: 28, Visits: 121
Vikas,

I'm running into same issue.

As soon as I'm starting SSIS Pacakge that kicks off the
exec [sys].sp_bcp_dbcmptlevel databasename set fmtonly on
select * from tblname set fmtonly off.


Did you get the solution why above process is starting and how to avaoid from getting it started.

Appreciate your inputs in advance.

-Stad.
Post #1339384
Posted Monday, August 05, 2013 5:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 4:13 AM
Points: 1, Visits: 339
Me also facing the same problem.

Can anyone help me?
Post #1480872
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse