SSIS - BypassPrepare what does this mean ?


  • Please look at SQL task, General > SQL Statement > BypassPrepare. It says that BypassPrepare indicates whether the task should prepare the query before executing it.

    What is meant by "prepare the query before executing it". Why do we need to do this ?

    Also, when I press "parse query" button for my SQL query, then I see this warning "this operation has no effect since bypassprepare property was set to true". What is the meaning of this and should I be concerned about it ?

    • Edited by Greg3tl Saturday, September 21, 2013 12:51 AM
    Friday, September 20, 2013 11:31 PM


  • Hi Greg,

    If you set this option to true then the preparing (i.e. parsing) is done by the database engine you are connecting to. If you set this option to false then the preparation is done by integration services package.

    This option is available only for OLEDB type connections and was introduced because pacakge (sql task) cannot prepare/parse all the SQL commands that OLEDB database supports. Meaning that you would get error in parse phase and would not be able to execute the statement that is valid statement on OLEDB database but cannot be prepared/parsed by SQL task.

    Regards, Dean Savović

    Saturday, September 21, 2013 4:53 PM