Unix Technical Forum

DTS -- SQL Server Data to AS400

This is a discussion on DTS -- SQL Server Data to AS400 within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I'm trying to dug this issue since couple of days but couldn't find any solution. I have SQL ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-29-2008, 04:25 AM
Noor
 
Posts: n/a
Default DTS -- SQL Server Data to AS400

Hi,
I'm trying to dug this issue since couple of days but couldn't find
any solution.

I have SQL server 2000 SP 3 and Host Integration Server 2000 SP 1
running. I'm able to download data from AS400/DB2(V5R2M0) into SQL
server, using Microsoft OLE DB Provider for DB2 in DTS.
But when I tried to upload the same table (downloaded from AS400 into
Sql server) back to AS400, I got the following error.


HResult of 0x8004206a(-2147213206) returned Unexpected error occurred.
An error result was returned without error message.


Anyone knows any thing about plese help me with this issue. I'll
really appreciate it.

Thanks in advance

Noor
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com