I have 2 connection defined in one local package

1- Entrepot: SQL OLEDB Provider for SQL Server
2- CRM: Saleslogix OLEDB Provider (which is actually a SQL Server 2000 as well)

I've defined an SQL Task, that is valid (syntax wise, the parse Query did not complain). At execution, it raises an error:

Package Error
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: bla bla bla

I'm not concerned about the error (actually I am, but this is not my question). I'm puzzled by the fact that the error identifies the source as being Microsoft OLE DB Provider instead of Saleslogix OLE DB Provider.

In the SQL TASK property, the CRM connection is selected.

What do you think about that ?

Thanks