I hope this message finds you well. I have a request regarding a specific task I'm working on. I need to transfer tables from one database to another as part of a backup process using SSIS. Specifically, I would like to check certain conditions, such as filtering data by date, and import only the records from the year 2022 into the backup database. Would it be possible for you to create a tutorial video on this topic? Your guidance would be immensely helpful. Thank you for your consideration.
For this particular task, you can use a data flow task, use an OLE DB source, write your query there to pull the data along with all filtering conditions, and then using the OLE Db destination you can insert the data to the respected destination table. You would need to repeat this method for all tables.
@@learnssis Thank you so much for the detailed explanation; it was very helpful. If it's not too much trouble, I would be incredibly grateful if you could create a practical video tutorial as well. A video would really help in understanding the steps more clearly and would be a great resource for those of us who learn better through visual examples. Your effort in making such a tutorial would be highly appreciated! 🙏
Take a look at this video. The only difference will be that in OLE DB source, you would need to select the SQL Command option and write the sql query there. ruclips.net/video/z78-R-SAZK4/видео.html
thank your sir
Thank you.
Thanks
You are most welcome.
Hello.Are the data you converted from JSON to Excel live data that changes over time, or are they fixed/static? Thank you
This is static data.
I hope this message finds you well. I have a request regarding a specific task I'm working on. I need to transfer tables from one database to another as part of a backup process using SSIS. Specifically, I would like to check certain conditions, such as filtering data by date, and import only the records from the year 2022 into the backup database.
Would it be possible for you to create a tutorial video on this topic? Your guidance would be immensely helpful.
Thank you for your consideration.
For this particular task, you can use a data flow task, use an OLE DB source, write your query there to pull the data along with all filtering conditions, and then using the OLE Db destination you can insert the data to the respected destination table. You would need to repeat this method for all tables.
@@learnssis Thank you so much for the detailed explanation; it was very helpful. If it's not too much trouble, I would be incredibly grateful if you could create a practical video tutorial as well. A video would really help in understanding the steps more clearly and would be a great resource for those of us who learn better through visual examples. Your effort in making such a tutorial would be highly appreciated! 🙏
Take a look at this video. The only difference will be that in OLE DB source, you would need to select the SQL Command option and write the sql query there.
ruclips.net/video/z78-R-SAZK4/видео.html
@@learnssis Thanks Sir ❤❤
I am not seeing "To Tables" button when trying to convert to JSON to Excel. Could you help?