Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS iSeries Source Duplicates Records Expand / Collapse
Author
Message
Posted Monday, January 28, 2013 12:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:25 PM
Points: 37, Visits: 533
I am creating a package to read data from our production iSeries (AS/400) and copying it into our new data warehouse. I am reading millions of rows at a time, and a couple of them will be updated while I am doing the read. The SSIS package is picking these records up twice, once before, and once after the update. I have tried changing the isolation level, but no luck.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstisol.htm
Looking at footnote P2, it appears that this may be by design. I have looked for a READPAST hint or something similar, but I haven't found anything.

Has anyone else dealt with this issue? Is there a way to solve it short of reading all the records into a pre-staging table prior to loading the staging table?
Post #1412601
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse