question

wondermorris avatar image
wondermorris 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
sharepoint
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
1 Like 1 ·
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)`
0 Likes 0 ·
Ok, now the question is better when we all know that you have empty rows. Which tasks (elements) do you have in your SSIS package? Add Data viewer between them and try to discover where the problem is (where you 'loose' your data).
0 Likes 0 ·
NULL concatentation causing empty records?
0 Likes 0 ·
@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.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.