Hi Team ,
I have a list of SSIS package which is controlled by master package to execute . And few of the packages are set to execute in parallel which are not having any dependency .
I have a SQL job which executes my master package ,and the JOB execution frequency is every 15 minutes throughout the day .
The requirement is such that i need to execute job for every 15 minutes .
Randomly i use to get one or other packages failed with below error
Failed to acquire connection DESTDataStore. Connection may not be configured correctly or you may not have the right permissions on this connection.
I am left with no clues which leads to this error , can anyone help me on this .