Hi Guys,
I have got a requirement from my client. Currently their DW loading is based on PowerShell and SPs. They have flat files which they load using powerr shell and there are few Stored procedures which loads the staging table, and fact tables. Currently this whole set up is connected to Azure and loading is happening to Azure DB.
Now I am told to migrate all these to SSIS. I have no idea how to start! Any suggestions on what would be the best approach?
Regards,
Shweta