100 Export data from multiple databases to CSV files using SSIS

[@ericsos101]

Awesome demo , can you make a video or if you have any how to export date from multiple sql server tables to multiple flat files in ssis

[@dbaunderdog]

I did the same thing but variable value not getting when evaluating the expression for Sqlquery variable. Simply it shows empty value.I am not figuring out the issue .

[@Mahmoudalgindy]

@Learn SSIS | Aqil
Allah reward you!
Thanks so much for your great the best tutorial I've seen ever.

[@learnssis]

Thank you Mahmoud Bhai.

[@srinivaschodavarapu7835]

Congratulations! Akhil 👏🎊🎆
On completion of making 100th video in SSIS. 😊🤘

[@learnssis]

Thank you so much Srinivas.

[@TheGargarpit14]

Hi Aqil, Your video is good, I followed through all the steps, I have some doubt, this works for the same table columns, if we have different columns in each table then?

[@learnssis]

Thank you. If we have different columns in each table then this logic won't work. We would then need to create separate data flow for each table.

[@MrEshwarprasad]

Hi Sir
Can you tell how to get data from share point,Shared folder and sftp servers

[@learnssis]

Hi Kamalkar, Sorry I never worked on pulling data from share point. If you get some files in the Shared folder and you can access the shared folder from windows explorer then you can access the files from SSIS as well. To get the data from sftp servers you can use some C# code. There is no inbuilt components, there are some third party component though.

[@swapnilvmestry]

Superb

[@learnssis]

Glad you liked the video Swapnil.

[@alexkinyua9241]

Ftp

[@learner_SSIS]

Hi sir,i follow same video in odbc MySQL ( MySQL workbench. And Hiedisql) not working

[@learnssis]

Yeah it won't work with MySQL and Hiedisql.