 | |
Re: DB2 AS400 "un"sucessfull
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: DB2 AS400 "un"sucessfull -
09-21-2004
, 04:28 PM
|
Hi, on SQL2000 SP3a I have a DTS package with a transform data task that reades a DB2 as400 table and writes into SQL. However, it only writes a single register (there should be 2 million of them) and the task says it was sucessfull!!!! how naive... can anyone help me? Thanks |
#2
| |||
| |||
|
|
I don't have an answer for you, but you're not alone. I ended up having to use a different machine because one SQL Server could hit our AS/400 and pull all rows, the other would only pull about 50-60 (on some files) and stop. I think we started having trouble after we modded a "file" on the AS/400 to include a new field or re-order them. Perhaps if it's possible to recreate the file from scratch with the field this wouldn't cause any problems? Other than that, you may want to try another machine and/or uninstall and reinstall your AS/400 client. -Pete "Miguel Salles" <MiguelSalles (AT) discussions (DOT) microsoft.com> wrote: Hi, on SQL2000 SP3a I have a DTS package with a transform data task that reades a DB2 as400 table and writes into SQL. However, it only writes a single register (there should be 2 million of them) and the task says it was sucessfull!!!! how naive... can anyone help me? Thanks |
the rows were cached and new rows ignored. I the Workflow properties did you
set close connection on completion?
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
#3
| |||
| |||
|
|
In article <5471l0pstjltb3hhq8o6qf1kl58t61elg2 (AT) 4ax (DOT) com>, Peter A. Schott wrote: I don't have an answer for you, but you're not alone. I ended up having to use a different machine because one SQL Server could hit our AS/400 and pull all rows, the other would only pull about 50-60 (on some files) and stop. I think we started having trouble after we modded a "file" on the AS/400 to include a new field or re-order them. Perhaps if it's possible to recreate the file from scratch with the field this wouldn't cause any problems? Other than that, you may want to try another machine and/or uninstall and reinstall your AS/400 client. -Pete "Miguel Salles" <MiguelSalles (AT) discussions (DOT) microsoft.com> wrote: Hi, on SQL2000 SP3a I have a DTS package with a transform data task that reades a DB2 as400 table and writes into SQL. However, it only writes a single register (there should be 2 million of them) and the task says it was sucessfull!!!! how naive... can anyone help me? Thanks This does sound remarkably strange. It lmost sounds as hough in your case Pete the rows were cached and new rows ignored. I the Workflow properties did you set close connection on completion? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.