sql server - Issue in concurrently running 2 instances of the same SSIS package in SQL Agent -

sql server - Issue in concurrently running 2 instances of the same SSIS package in SQL Agent -

i created basic ssis bundle in sql server 2012 testing concurrency using sql server agent jobs. want able run copies of same bundle part of different jobs.

package design: there variable in bundle called threadid represent thread in bundle running. variable included in configuration xml file below: - 1

there 1 task in package. simple exec sql task passes threadid stored procedure , stored procedure writes threadid in sql server table.

result: works fine when execute 1 re-create of bundle in vs ide or sql server agent job. issue shows when run 2 instances of same bundle package concurrently in 2 different sql agent jobs. each job has re-create of bundle file , configuration xml file. 1 xml file has threadid=1 , 1 has threadid=2. see in sql server table threadid of job first started. table contains 1 when start first job , sec job. 2 when start sec job first.

any thought why?

thanks

sql-server ssis