I'm trying to run an update query in the middle of the SSIS package and doing it via SQL rather than using all of the built in logic gates is preferred to avoid the headache. The issue I'm running into is that if I return no results, it gives me an error:
Error 1 Validation error. No column information was returned by the SQL command.
Locally I originally had:
SELECT 1 [placeholder]
at the end of my query to trick it into executing, but when I imported this package to SQL Server as a job to automate, it skipped this update because SELECT 1 [placeholder] is never used so it views it was "unnecessary code":
Error: Update has been removed from the Data Flow task because its output is not used and its inputs either have no side effects or are not connected to outputs of other components. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.
So I turned to my SSIS package and went to set HasSideEffects = True, but it's greyed out and won't let me change it, so now I'm unsure what to do. How can I resolve this without using the built in logic gates? Any help would be appreciated. Thanks!
Thanks to Brad's help, realized I need to use "Execute SQL Task" not "Data Flow Task".