Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS: PRoblem with connection
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00963616
Message ID:
00963664
Views:
12
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform