How to migrate data from MySQL to SQL Server using Devart SSIS

[@furkanlj]

Awesome video thanks man

[@learnssis]

Thank you.

[@naveenkumarreddy1556]

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

[@learnssis]

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.

[@zaphod5536]

how to do the same thing without devart using just ssis ?

[@learnssis]

Take a look at this video, and for your case use ADO Net source and OLE DB Destination kzbin.info/www/bejne/n4SwZaeKpcmMnLs

[@BN-ys1sj]

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.

[@learnssis]

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-ys1sj]

@@learnssis Thanks Aqil, yea there isnt an inbuilt component.