September 20, 2013 at 5:32 pm
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 ?
September 23, 2013 at 5:51 am
Hi
This property provides the ability to bypass the prepare command for OLE DB connections, because prepare does not support some Transact-SQL keywords, if you are using a parameterized query in your execute SQL task you must insure this property is set True or the task will fail.
Please do a simple test:
Add string variable with value @@VERSION to your package.
Set SQLStatement: SELECT ? in Execute SQL Task.
Add your variable in Parametr Mapping.
Execute your task with BypassPrepare is False and then True, You will see the result.
Br.
Mike
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply