What are the effects of setting IsolationLevel transaction property - ProProfs Discuss
Topics
Products
Follow Us:

What are the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos?



A. It prevents pending changes from more highly isolated transactions from being overwritten
B. It prevents shared locks from being issued and exclusive locks from being honored.
C. It prevents other users from updating the data.
D. It reduces blocking by storing a version of data that one application can read while another is modifying the same data.

This question is part of MSBI SSIS Quiz
Asked by LmAkshay, Last updated: Jun 29, 2020

+ Answer
Request

2 Answers

M. Kennedy

M. Kennedy, Web Content Writer, Denver

Answered Sep 14, 2018

The data flow task cocoons the data flow engine that shifts data between sources and targets and lets the user convert, clean, and modify data as it is moved. Incorporation of a data flow task to a container control flow makes it feasible for the package to remove, transform and load data.

An information flow consists of at least one data flow element, but it is typically a set of connected data flow sources that extract data. If a task copies many sets of data, and if the order in which the data flows in the data flow task.

 

lmAkshay

LmAkshay

Answered Jul 16, 2018

It prevents pending changes from more highly isolated transactions from being overwritten

####
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.