We can do this using Expression and File System task. Containers are just for placing other tasks in them like Sequence container. And foreach loop and for loop containers are there just to run a loop in SSIS.
Hi Aqil sir, How import tables from different servers in ODBC (MYSQL) using SSIS and select data from multiple ODBC servers(MySQLworkbench and Heidisql)
ok Aqil sir , you have uploaded many OLEDB related videos.so please will upload atleast one Odbc dynamic connection videos Import table different servers, select data from multiple ODBC connection
@@learner_SSIS We can't make the ODBC connection dynamic, if the tables are on the same database then we can fetch the data but if the tables are on different servers then you would need to create multiple ODBC connections for each server.
Thank you so much for this video, I learned so much.
Good to know that the videos are helping you to learn the new things.
Very well done video. Thank you.
You are most welcome Erwin.
Hi, thanks for the amazing video. Can we do the same task by using containers?
We can do this using Expression and File System task. Containers are just for placing other tasks in them like Sequence container. And foreach loop and for loop containers are there just to run a loop in SSIS.
hi aqil nice video
any other way with out using C#
Thank you Tejas, yeah we can use File System task as well to create the folders.
@@learnssis Txs for respond
Hi Sir.
Can you please tell how to learn C# codes. Otherwise please make C# coding videos.
I am planning to make C# coding videos from beginners level.
@@learnssis thanks bhaiyya i m eagarly waiting for c# videos
Hi Aqil sir,
How import tables from different servers in ODBC (MYSQL) using SSIS and select data from multiple ODBC servers(MySQLworkbench and Heidisql)
I think you would need to create multiple ODBC connections for this requirement, single ODBC connection won't work here.
ok Aqil sir , you have uploaded many OLEDB related videos.so please will upload atleast one Odbc dynamic connection videos
Import table different servers, select data from multiple ODBC connection
@@learner_SSIS We can't make the ODBC connection dynamic, if the tables are on the same database then we can fetch the data but if the tables are on different servers then you would need to create multiple ODBC connections for each server.
Hi Aqil sir very good morning
I have tried multiple ODBC connection i m not get output.please make a video sir
@@learnssis ODBC (MySQL) dynamic connection is done successfully for you given ideas.thank you Aqil sir