Hi Sir, I need to load a specific monthly file(All files) using Ssis. How to do it? Please Explain. Example:- If I need an August month-Load all August month files into the sql server table. If I need a February month - Load all February month files into the sql server table.
For this one we need to use the foreach loop container with file enumerator, thus it will loop through all files, now inside foreach loop container we can put an script task and inside script task we can get the either create date or modified date for a file, and from the date we can get the month using c#. Now we need to declare an ssis variable month_name of type string and can pass the value to the script task and now compare this value with the value from month got from date and if they are equal then assign the value to an ssis variable like "Value matched" and then after the script task between the data flow task, we can use precedence constraint like If ssis variable=="Value matched" I will try to make a video on this one.
Hi sir thanks for sharing your knowledge. Can you please make a video on ssis package if user pass db name and table name and the package export all the data from table to excel
Hi Bhupathi, Sorry I was out of station thus missed to reply to you on this, actually we already have a video very similar to your question, where I shown how to export data from sql server table to excel file. th-cam.com/video/ZE7jlWuqsvU/w-d-xo.html The only change here will be that we just need to declare 2 variables, one Database name and second table name and just pass the value of database to connection string and just pass the sql table name to the sqlquery used in this code.
Very Nice Aqil Can you make a video on have to execute the package by changing the parameters in a table . For example usually we will take load sysdate -3 through ssis . if we want to take load for 20days if we updated in table and run package it should take the for 20days .
Hello aqil sir . I have been learning SQL since a week and now I am pretty much familiar with SQL queries.. will I get a job on SQL only ? If yes then please let me know how ?
Great video! Each time you update the package, do you have to redeploy to the ssis catalog?
Yes we need to redeploy it.
Bro, did you have any idea how to get the current date folder from SharePoint to the local folder by using a PowerShell script?
Sorry I haven't worked on SharePoint.
Thq soo much aqil
Thank you Harish.
Great Aqil sir 😀
Thank you Naveen.
Execelente!!! Muito obrigado!
Thank you.
this is very helpful я
Glad to know that you liked the video.
Hi Sir, I need to load a specific monthly file(All files) using Ssis. How to do it? Please Explain.
Example:- If I need an August month-Load all August month files into the sql server table.
If I need a February month - Load all February month files into the sql server table.
For this one we need to use the foreach loop container with file enumerator, thus it will loop through all files, now inside foreach loop container we can put an script task and inside script task we can get the either create date or modified date for a file, and from the date we can get the month using c#. Now we need to declare an ssis variable month_name of type string and can pass the value to the script task and now compare this value with the value from month got from date and if they are equal then assign the value to an ssis variable like "Value matched" and then after the script task between the data flow task, we can use precedence constraint like
If ssis variable=="Value matched"
I will try to make a video on this one.
@@learnssis Thank you so much Sir. . I will waiting for your Video. . Thanks a lot.
Hi, can you make a video using power automate how to automate the ssis package execution whenever a new file added in SharePoint.
Sorry I never worked on SharePoint nor power automate.
Hi sir thanks for sharing your knowledge. Can you please make a video on ssis package if user pass db name and table name and the package export all the data from table to excel
Hi Bhupathi,
Sorry I was out of station thus missed to reply to you on this, actually we already have a video very similar to your question, where I shown how to export data from sql server table to excel file.
th-cam.com/video/ZE7jlWuqsvU/w-d-xo.html
The only change here will be that we just need to declare 2 variables, one Database name and second table name and just pass the value of database to connection string and just pass the sql table name to the sqlquery used in this code.
Very Nice Aqil
Can you make a video on have to execute the package by changing the parameters in a table .
For example usually we will take load sysdate -3 through ssis . if we want to take load for 20days if we updated in table and run package it should take the for 20days .
Yeah Satish it will good to make such video, will try to create one.
@@learnssis Thanks in advance
Hello aqil sir . I have been learning SQL since a week and now I am pretty much familiar with SQL queries.. will I get a job on SQL only ? If yes then please let me know how ?
I think you should try to learn either ssis or SSRS or power bi along with SQL then it will be easy for you to get the job.
@@learnssis ok thank you
If you have any idea let me about this because now i am working on same kind of task
Sorry I don't have any idea about power automate or SharePoint.
TY I LOVE U
Love you too :)