Blocking on server when running package

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  March 16, 2009 at 7:27 am

  #127153

  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

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  March 16, 2009 at 12:00 pm

  #960490

  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? :ermm:

  -Vikas Bindra

• Stad

  SSC Eights!

  Points: 964

  More actions

  August 2, 2012 at 11:04 am

  #1521023

  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.

• biwarrior.viswa

  Valued Member

  Points: 73

  More actions

  August 5, 2013 at 5:03 am

  #1638564

  Me also facing the same problem.

  Can anyone help me?