Suppose I have oen SSIS package that update to ONE table and multiple users are executing that package (using Agent JOB). SO is there any chance that the package will fail for some user, due to table lock?
Note: For my OLEDB Source component I am using SQL query with a where condition for that user and that insert to OLEDB Target SQL Table.
If Yes, How should I handel multiuser situation here so that all users can insert into the same table.
View Complete Post