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?