I've always had problems pulling data from our AS400/Iseries to our SQL Server 2000 server. They just don't seem to like each other. The only thing that works well is DTS.
Now I am trying to pull data into SQL Server 2005 Express via SSIS and I am having problems.
I right click my database, select 'tasks' and the
'import data' to start up the SSIS wizard. I select IBM DB2 UDB for Iseries IBMDA400 OLEDB Providor, click on properties and fill in the ip address, username etc and test the connection successfully.
I set up a select statement to pull in the data I want but when trying to edit the mapping, I get a pretty useless error message.
'Column information for the source and destination could not be retrieved. No error message available, result code
B_CANTCANCEL (0x00040E15)'.
Can anybody give me some pointers on eactly what is going wrong here?
Dazed and confused
Now I am trying to pull data into SQL Server 2005 Express via SSIS and I am having problems.
I right click my database, select 'tasks' and the
'import data' to start up the SSIS wizard. I select IBM DB2 UDB for Iseries IBMDA400 OLEDB Providor, click on properties and fill in the ip address, username etc and test the connection successfully.
I set up a select statement to pull in the data I want but when trying to edit the mapping, I get a pretty useless error message.
'Column information for the source and destination could not be retrieved. No error message available, result code
B_CANTCANCEL (0x00040E15)'.Can anybody give me some pointers on eactly what is going wrong here?
Dazed and confused