Hi Aqil What if we deploy ispac file of the above package in sql server? Will it execute without error. Because the above ssis etl is different from microsoft product SSIS. Will sql server (ms sql) support devart SSIS
@learnssis4 ай бұрын
You would need to install the Devart SSIS components on the server on which you are deploying the SSIS packages to. Yes SQL Server supports Devart SSIS components.
@BN-ys1sj6 ай бұрын
Hi Aqil your videos on ssis and SQL are awesome, just one question. Is it possible to use the contents in sharepoint as a data source for ssis? I tried to get information from an excel sheet in sharepoint to ssis, but I didn't get far.
@learnssis6 ай бұрын
Although I have not worked with sharepoint much, but as far as I know there is no inbuild component in SSIS for reading data from sharepoint side, I will see if Devart provides any components for reading data from excel sheet in sharepoint.
@BN-ys1sj6 ай бұрын
@@learnssis Thanks Aqil, yea there isnt an inbuilt component.