Are you sure you picked correct OLE DB provider for CRM connection or that error did occur on CRM connection?
>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
--sb--