564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|How and when to use the Execute SQL task PARSE QUERY button in SSIS|
|A short blog explaining how the Parse Query property and BypassPrepare property for an SSIS task are related.|
In answer to a question from a recent course: what does the Parse Query button do?
The Parse Query button for an Execute SQL task.
When you click on this button, SSIS displays this message:
You can't proceed while the BypassPrepare property is set to True.
So you could now set this property to False:
The BypassPrepare property is now set to False.
And now when you parse the query, it works:
Because this was valid SQL, the query now parses correctly.
The obvious question is: why did we have to change the BypassPrepare property? The answer is that by default SSIS will use its own logic to prepare a SQL statement, whereas if you set the property to False the SQL statement will be passed to the SQL Server database engine for checking.
If you are using parameterised queries and change the BypassPrepare statement to False, your package will fail.
Given all this, there seem to be two sensible courses of action. Either:
Quite why Microsoft couldn't do all this behind the scenes for you is beyond this owl ...
25 Aytoun Street