How many rows are there in the SharePoint List?MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

Hi all, I have a sharepoint source ..i need to get the data from sharepoint list. My sharepoint list having 20 columns and i can see columns in my sharepoint component and i tried batch size as 1000,500,100,50 but the package is running so long more than 25 mins in yellow color and it never turned to green... what might be the problem..?? i am storing this data into a stagging table. Help me please .. Thanks in advance.

How many rows are there in the SharePoint List?MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

there are almost 100 columns we need to filter the columns to 20 columns there is no condition to select the columns Eg: columns are col1, col2,col3....col100 in the sharepoint list. i need to get only col1,col2,co3,col4,col5 in my table which is in the database. can you give an idea how write a caml query for this selecting particular columns in the sharepoint list..?? List Name : List1 List view Name: View1 url: https:\\abc\