I have a job that includes 4 seperate tasks, and when I open VC, I get this
error messge for each one of the tasks.
"Could not add task: [Task Name], error: ForeignKeyConstraint
Constraint1 requires the child key values (4c77b1ef-b467-4558-927f-161a2c676bf4,
7b138cf-a1b6-4a88-be9b-d552999e9cfe) to exist in the parent table."
I don't have an expand option anymore to see the tasks in the parent job in the groups jobs window but when I open the job itself, they appear in the task tab.
The tasks are: 2 SQL Queries (basic selects, returns a single value), and 2 Emails that send each of the output values.
Now, the results of the SQL Queries don't get called for the email task (Email shows a blank where the value should show.
Seems like the query output value isn't being stored properly.
(Made sure the Store Standard Output check box is checked)
Strange. Any advice is much appreciated!
Edited by user
| Reason: Not specified