asked
SharePoint Import
Hello SSC, I have a SSIS package in place which imports data from share point(3000 items)to sql table (List_Archive). The package runs successfully. At sql end row count also matches with share point item count. Problem is that many sql rows have no data at all. For example ID column would start with ID 1 go upto ID 15 and than goes to ID 19. So it's missing ID's. But missing ID's are there in share point list. Pl help me as where to start looking. Thanks
How it is possible that row count matches with share point item count and you have missing IDs? Do you have empty rows in your List_Archive table? Try to select data from List_Archive table with SELECT * FROM List_Archive ORDER BY ID. Maybe you have that missing IDs somewhere in the middle of table.
Yes this suggests that on viewing the data you are assuming some order without specifying it. Also what happens when you try and query explicitly for those 'missing' IDs - `select * from List_Archive where ID in (16,17,18)`
@Sule, I know it sounds impossible but it happening. I did try SELECT * FROM List_Archive ORDER BY ID and checked but missing ID's are not there. I tried 'Data viewer' as well but no help. @KEV, SELECT * From list_archive where id in (16,17,18) results 0 rows.
16 People are following this question.
