Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
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 ...
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.