OTF (3/15/2013)
The OLE DB Command Task will execute a Sql Command for every row in an ssis dataset.
...
This is probably why the Delete is slow.
Not probably. It's with great certainty you can say the OLE DB command is the reason for the slow performance.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP