How can u remove my post ? Data migration from AS400 to Sql2005

Hi,

Yesterday I had posted a query of How to transfer the Data from AS400 files to Sql 2005 tables with DTS and the error I received for the same. I am not able to view the replies since it has been deleted. Pls repost the same. I posted the query expecting for a solution but instead my question was deleted..... the very purpose of forum is defeated.

Regds,

Anu

anu_ank wrote:

Hi,

Yesterday I had posted a query of How to transfer the Data from AS400 files to Sql 2005 tables with DTS and the error I received for the same. I am not able to view the replies since it has been deleted. Pls repost the same. I posted the query expecting for a solution but instead my question was deleted..... the very purpose of forum is defeated.

Regds,

Anu

Its possible that it was received because the question was concerning DTS. This is not a DTS forum.

Having said that, removing someone else's posts is completely improper. I would hope nobody would ever do that without a very good reason.

-Jamie

|||

Hi,

I want to migrate data from AS400 to Sql2005. From the Sql Management studio I invoke the Import Data wizard. For the source I connect to the ISereis system and for the Destination I select the Sql2005 Database , When I go to the next step i.e select source tables I get the error
"An error has occured which the SQL Server Integration Wizard was not prepared to handle
No error message available,result codeB_E_CANTCANCEL(0*80040E15).(System.Data)" .After this I am unable to proceed .

I am using Client Access tool to connect to ISereis and the provider is "IBM DB2 UDB for isereis IBMDA400 OLE DB Provider"

I posted this question since I received the SSI error. If this is not the right place pls direct me to which forum I should post the above query .

Regds,

Anu

|||

I have not been successfull with the driver you mention. I am using AS400 iseries for V5R4

I would suggest you try with the oledb for ODBC driver or the microsoft driver, that I have been using recently in an SSIS package:

Microsoft DB2 driver

go to http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/featurepacks/default.mspx

and select the feature packs , in the list of feature packs you will see the Microsoft OLEDB Provider for DB2

|||

anu_ank wrote:

Hi,

Yesterday I had posted a query of How to transfer the Data from AS400 files to Sql 2005 tables with DTS and the error I received for the same. I am not able to view the replies since it has been deleted. Pls repost the same. I posted the query expecting for a solution but instead my question was deleted..... the very purpose of forum is defeated.

Regds,

Anu

When viewing your profile, you can click on the "Search" button. That will show you your threads you have started.

Your post is not deleted. It is in the SQL Server Tools General forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1487606&SiteID=1