SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Blocking on server when running package


Blocking on server when running package

Author
Message
Old McDonald
Old McDonald
Right there with Babe
Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)

Group: General Forum Members
Points: 770 Visits: 994
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
Old McDonald
Right there with Babe
Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)

Group: General Forum Members
Points: 770 Visits: 994
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
Stad
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 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.
biwarrior.viswa
biwarrior.viswa
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 350
Me also facing the same problem.

Can anyone help me?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search