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 |
|
anu_ank
Starting Member
1 Post |
 Posted - 2007-04-16 : 01:27:44
|
| Hi, I am using the DTS tool to Copy tables/date form AS400 files to Sql2005. When I enter the query select * from tableas4000 then I can see all the rows, the statement is parsed in the next step I get the error"An error occured which the SQL Server Integration services wizard was not prepared to handle.No error message available,result code:DB_E_CANTCANCEL(0*80040E15).(System.Data)".How do I solve this? I am using IBMDB2 UDBFOR ISEREIS IBMDA400 OLE DB PROVIDER.Pls give a solution to this problem |
|
|
nichols-g
Starting Member
1 Post |
Posted - 2009-04-15 : 13:15:39
|
| was this item ever resolved? |
 |
|
|
Skoorb
Starting Member
1 Post |
Posted - 2009-11-05 : 07:47:11
|
| I am having the exact same problem. I am using the same provider and this is with SSIS and Service Pack 3 of SQL Server 2005. The most irritating part about this is that when I create the package the data does in fact pull from the table during preview; I can see everything I want but I also get this message and thus cannot save the package.I have found nothing else on the net about this despite heavy googling--at least nothing with any resolution. Something from IMB talking about it being a SP1 problem but that's not relevant to SP3.In any case, SQL Server 2005's iseries 400 adapter does not work for me and, evidently, for many people as they just use the .net odbc one. The annoyance with that one is password management; you have to jump through hoops to put the password through to your SSIS package. |
|
|
|
|
|
|
DB_E_CANTCANCEL(0*80040E15).(System.Data)