SSIS Package failing in VS and on server (yes it has worked before - came back to after a few months) - Task Send Mail Task - but I don't have any email task in my package so where is this coming from? I tried rebuild and still not working any ideas what to look for.
My package has a single dataflow task, source is SQL Server, Destination is API call. Fails on the first step i.e. the source assistant and it never shows the working gear icon only on the outer dataflow task.
[Send Mail Task] Error: An error occurred with the following error message: "The connection "{098C3882-D2EE-4E72-B6C5-96354BC240C1}" is not found. This error is thrown by Connections collection when the specific connection element is not found. System.Runtime.InteropServices.COMException: The connection "{098C3882-D2EE-4E72-B6C5-96354BC240C1}" is not found. This error is thrown by Connections collection when the specific connection element is not found. ".
SSIS Package failing in VS and on server (yes it has worked before - came back to after a few months) - Task Send Mail Task - but I don't have any email task in my package so where is this coming from? I tried rebuild and still not working any ideas what to look for.
My package has a single dataflow task, source is SQL Server, Destination is API call. Fails on the first step i.e. the source assistant and it never shows the working gear icon only on the outer dataflow task.
[Send Mail Task] Error: An error occurred with the following error message: "The connection "{098C3882-D2EE-4E72-B6C5-96354BC240C1}" is not found. This error is thrown by Connections collection when the specific connection element is not found. System.Runtime.InteropServices.COMException: The connection "{098C3882-D2EE-4E72-B6C5-96354BC240C1}" is not found. This error is thrown by Connections collection when the specific connection element is not found. ".
Share Improve this question edited Apr 2 at 3:18 Glen asked Apr 2 at 3:12 GlenGlen 7902 gold badges13 silver badges32 bronze badges1 Answer
Reset to default 0Oops it had an event handler with a send email task. Someone delete this post please.