Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chowda
Starting Member
2 Posts |
 Posted - 2007-01-25 : 05:20:04
|
| howdy,i have a sqlserver2005 ssis package which connects to a mysql webserver to upload data. i am connecting via mysql oledb connection and am able to test connect ok through the oledb connection manager. However in my ole db destination editor i get an 0x80040E21 error when trying to preview a table . The full error is :Error at Data Flow Task [Destination - Query [70]]: An OLE DB error has occurred. Error code: 0x80040E21.Error at Data Flow Task [Destination - Query [70]]: Opening a rowset for "INFORMATION_SCHEMA.address_book" failed. Check that the object exists in the database.------------------------------ADDITIONAL INFORMATION:Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)I can see all the tables in the drop down box in connection manager. This has been driving me nuts for the last 3 days! I have tried changing some of the security connection settings to no avail, (although i am not sure on what these do).I have also tried setting up as an odbc connection using script components but had memory errors after copying several hundred records and the package just hangs. I can go into this in more detail however i dont think they are related issues and i would prefer oledb as i dont have to script my data transfer.any help much much appreciated.thanks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-25 : 05:27:14
|
| INFORMATION_SCHEMA.ADDRESS_BOOK? Is that valid Information schema view?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-25 : 19:04:14
|
| Is the mysql driver tested for use with SSIS?I've had a similar problem with sybase on a 64 bit system and it just doesn't work.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
chowda
Starting Member
2 Posts |
Posted - 2007-01-26 : 05:11:52
|
| thanks, will check out the mysql driver at some point.- i was using the corelabs one,will try bytefx, and i have given up for the moment and got it working with odbc and scripting as i have a deadline today.as for information_schema.address_book, not sure also if the driver handles the front schema name, so that could be a problem too.thank you both for the pointers. i'll post a solution here if i get it sorted! |
|
|
|
|
|
|
ssis oledb connection Error code: 0x80040E21.