Hi Sir, I Have doubt in SSIS project I searched a people who know well about SSIS. If you are in helping mind please give your help. My doubt was I want create a project which will execute automatically choose a excel file by related filename from local directory and load data into SQL server can you give any solution for this project.
Thanks for your question, currently I don't have a video on this topic on my channel. If you think that excel file format will be same, then you can use a foreach loop container with file enumerator and assign the excel file path value to an ssis variable and then you can use a data flow task to load the data from excel to sql table. In excel connection you can change the excel file path using the ssis variable used in foreach loop container. You can check how to use foreach loop container here :th-cam.com/video/cqw1Ce28FUs/w-d-xo.html And here you can check how to load excel file to sql server table: th-cam.com/video/12_JoGTTuH8/w-d-xo.html If the format of excel file can change, then you would need to write some scripting in C#, but most of the code is already pre written, I found a nice vide for you where you can use C# code to dynamically load an excel file to sql server table. But of course you would need to change it a bit and test it for your case th-cam.com/video/wUxpc0CruSo/w-d-xo.html
As you can see in the SSIS package if the package is executing successfully then we are inserting a record into config table for execution count. Not sure what is missing from your side.
@@BTECH123 It does not matter if you execute it manually or execute it automatically from sql agent job, the package will run only once regardless called multiples either manually or from sq agent job.
@@learnssis the title of video is given as once a day sir thats why. If i run tommorow without and getdate () will it run one time again sir. Because day not coded.
@@BTECH123 In the title I have given once in a day, so it means once every day. The package will run today once and it will run once tomorrow as well because day will change. You would need to use the same code what I have written in the SSIS package and shown in the video. Yes we would need to use GetDate() there as show clearly in the video.
Ur videos are too good ! Keep on posting sir !and if possible please try to make more video azure data factory too
Thank you so much for supporting. Yeah Azure data factory and Power BI is in my list. Keep watching :)
Thank you very much
Thank you for your support.
Hi Sir,
I Have doubt in SSIS project I searched a people who know well about SSIS. If you are in helping mind please give your help.
My doubt was I want create a project which will execute automatically choose a excel file by related filename from local directory and load data into SQL server can you give any solution for this project.
Thanks for your question, currently I don't have a video on this topic on my channel. If you think that excel file format will be same, then you can use a foreach loop container with file enumerator and assign the excel file path value to an ssis variable and then you can use a data flow task to load the data from excel to sql table. In excel connection you can change the excel file path using the ssis variable used in foreach loop container.
You can check how to use foreach loop container here :th-cam.com/video/cqw1Ce28FUs/w-d-xo.html
And here you can check how to load excel file to sql server table: th-cam.com/video/12_JoGTTuH8/w-d-xo.html
If the format of excel file can change, then you would need to write some scripting in C#, but most of the code is already pre written, I found a nice vide for you where you can use C# code to dynamically load an excel file to sql server table. But of course you would need to change it a bit and test it for your case
th-cam.com/video/wUxpc0CruSo/w-d-xo.html
ExecutionCount Not updating sir
As you can see in the SSIS package if the package is executing successfully then we are inserting a record into config table for execution count. Not sure what is missing from your side.
If we give and getdate() its not executing only once. If i remove only its executing only once. Is it manual execution every day once sir?
@@BTECH123 It does not matter if you execute it manually or execute it automatically from sql agent job, the package will run only once regardless called multiples either manually or from sq agent job.
@@learnssis the title of video is given as once a day sir thats why. If i run tommorow without and getdate () will it run one time again sir. Because day not coded.
@@BTECH123 In the title I have given once in a day, so it means once every day. The package will run today once and it will run once tomorrow as well because day will change. You would need to use the same code what I have written in the SSIS package and shown in the video. Yes we would need to use GetDate() there as show clearly in the video.