SSIS package for import csv file has been configured with SQL server agent which run every 2 min.
Experiencing, SQL process suspended with result sys.sp_describe_first_result_set;1
When : ONLY at VERY first time (when Azure VM created) with more than one csv file import.
When not :
- If any single CSV file import has happen before.
- If point 1 has been followed , we can rapid import any number of csv file.(no sql suspend)
SQL Process suspended with sys.sp_describe_first_result_set return 1
Details of suspended :
Blkby = -2 = orphaned distributed transaction
Suspended : session is waiting for an event to complete
Command : Execute
CodePudding user response：
Issue has been resolved by removing <DTS:TransactionOption = "2" from SSIS package
It was not properly implemented in my case ,follow for more details https://learn.microsoft.com/en-us/sql/integration-services/integration-services-transactions?view=sql-server-ver16
Below are TransactionOption values NotSupported : 0 Supported : 1 Required : 2