Improving Workbook Behavior

Dean_Gross If you go to the Advanced Settings tab of the step that will provide the parameter, look at the parameters being exported. When setting up a parameter that gets exported, you can setup a default value as well.  I would recommend setting that to a value that will cause no rows to be returned in your query but will not return an error.

For text values I typically set this to an empty string and for integers I use zero but it will all depend on the query where it the parameter will be used.