SSIS : SharePoint List Source and Destination + Excel

Nov 11, 2009 at 9:02 AM

hello everyone

i have 2 problems

1-i wanna import data from excel to sharepoint list but i can't import data because that i have lookup field in sharepoint list.

what's your suggestion?

 

2-i can't imoprt data from excel to sharepoint list(whitout lookup field in sharepoint list) because i have 12,000 records in excel.

when run this program , excel source read 700 records only...

what's do you think about it?

 

 

Dec 8, 2009 at 3:25 AM

Hi there,

In my humble opinion, make life easy for yourself, just create a named range in excel and use SSIS to pull the entire excel spreadsheet into a SQL table and then do what you want with it. That way you can do any lookups etc and the amount of rows is a non-issue. 

 

Hope that helps