ssis - choosing the value of BypassPrepare property -


i know setting "bypassprepare" property true means preparing (parsing) query done database engine i'm connecting to. otherwise preparation done integration services package how matter whether parsing done on ssis side or database engine side. want make best choice.

thanks ,

if set option true preparing (i.e. parsing) done database engine connecting to.

if set option false preparation done integration services package.

this option available oledb type connections , introduced because pacakge (sql task) cannot prepare/parse sql commands oledb database supports. meaning error in parse phase , not able execute statement valid statement on oledb database cannot prepared/parsed sql task.


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -