Insert and update DB2 from SQL Server 2000 using OLEDB
Home > IT Answers > AS/400 > Insert and update DB2 from SQL Server 2000 us...
Sandy55
5 pts.
0
Q:
Insert and update DB2 from SQL Server 2000 using OLEDB
AS/400, SQL Server 2000, DTS
I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server.
When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error, but no update or insert.
I am working on that for already 2 months and no improvement.
Plz help me.
ASKED: Feb 6 2008  9:42 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
How are you moving the data from the SQL Server to the AS/400? Are you using a data transformation, linked server with the query being run by the DTS package, etc?
Last Answered: Feb 9 2008  2:13 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Feb 22 2008  6:13AM GMT

Were you able to resolve the issue?

 
0