I get an error using dts:
DATA TRANSFORMATION SERVICES: Data Pump Exception Log
Package Name: Copy Artists to MySql
Package Description: (null)
Package ID: {468D902D-AE82-4522-84C0-3B4C36A19B42}
Package Version: {0C4FE394-037C-41D2-AB46-D28E3966A161}
Step Name: DTSStep_DTSDataPumpTask_1
Execution Started: 1/30/2006 12:00:01 PM
Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error Help File:
Error Help Context ID:0
1|A-HA|
1|A-HA|
Execution Completed: 1/30/2006 12:00:01 PM
Also get these errors (not during dts, but it could have something to do with it)
Microsoft Data Link Error
Test connection failed because of an error in initializing provider. Catastrophic failure
OK
I had already have copied the patch files so that's not the problem:
MyODBC-3.51.10-2
Patch 3
