Hi, you would need to write code in C# to download the files from Sharepoint to your local folder on the server. There is no inbuilt code to read the files directly from sharepoint. stackoverflow.com/questions/58034425/download-file-from-sharepoint-online-using-c-net
If your column should contain only numeric values and there are special character present in the data that you want to identify and move the column value into another column then you can use the IsNumeric function like select isnumeric(column) from tablename and you can update data to another column like update a set secondcolumn = case isnumeric(column) when 1 then column else 0 end from tablename a
Dear Aqil, please let us know how to split 234?4535?67?8978?99 means special character contains rows into columns.
Hi... How to read Excel files from SharePoint folder using ssis
Hi, you would need to write code in C# to download the files from Sharepoint to your local folder on the server. There is no inbuilt code to read the files directly from sharepoint.
stackoverflow.com/questions/58034425/download-file-from-sharepoint-online-using-c-net
One of my column contains 398?6666?76?889?9874 this kind of data and my requirement is will have to split it into separated columns. Kindly help ASAP😊
If your column should contain only numeric values and there are special character present in the data that you want to identify and move the column value into another column then you can use the IsNumeric function like
select isnumeric(column) from tablename
and you can update data to another column like
update a
set secondcolumn = case isnumeric(column) when 1 then column else 0 end
from tablename a