I have been trying to create two dififernt task that are supposed to create two different Global tables (need parallel creation of two Global temp table) on the same DB server using same OLE DB connection,But i can find only one of the table is getting created.
It works if i create two different OLE DB connection with the same DB credential and use it in each task .it is letting me create two Global Temp table on the same DB server parallely.
Kindly Explain what am i missing here and what are the possible solution to create Global temp tables parallely using an ssis on the same DB server
slaiman muneer is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.