February 25, 2009 at 7:48 am
What does the BypassPrepare option do? Currently, the package I'm working on has the value set to False. What happens if I change it to True?
Thanks,
Curt
May 4, 2011 at 3:33 am
If you set the BypassPrepare property to true then your SQL statement will be prepared or compiled before execution. In that way the query does not need to be compiled every time before execution. I set the BypassPrepare property to true as soon as I'm happy with my SQL statement and I parsed it with the "Parse Query" button. It's good practice to set BypassPrepare to true whenever you're ready to deploy your packages to production. Please also note if the BypassPrepare is set to true then parsing with the "Parse Query" button will have no effect.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply