Thanks for your question, I will create a dedicated video on it, however I have covered it in below example as well, check this one ruclips.net/video/6AIM3xkO0H8/видео.html
Very helpful video sir..just have one question regarding the project variable,A project variable value will be same for all the packages in it or it can be different ?
Hi Aqil sir, 5 I deployed ssis package on sql server 2019. Thereafter scheduled a sql job to run this ssis package weekly. When I started a job for the first time, it failed with following error. Package execution on IS Server failed. Execution ID: 6, Execution Status:4. To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report Started
In the SSIS catalog, where you can see all deployed projects, right click on project name, go to reports and select All executions and you should be able to see all executions reports. Click on the failed execution and check the error message.
Hi Aqil sir, i created package for data move different server, source connection string Heidi SQL and destination server MySQL workbench but deployed package in SQL server 2019 successful &run but jobs is failed
Thank you so much sir now a days everyone is making money from thier skills but you were helping the people to gain skills without expecting money.🙏
Can you create a video on using a variables value in an sql statement in SSIS. Thanks.
Thanks for your question, I will create a dedicated video on it, however I have covered it in below example as well, check this one
ruclips.net/video/6AIM3xkO0H8/видео.html
Thank you mate, really helpful
You are most welcome.
Is this possible that in execute sql task I execute the task based on number of rows affected
Yeah of course we can do that as well.
Very helpful video sir..just have one question regarding the project variable,A project variable value will be same for all the packages in it or it can be different ?
Hi Paresh, the value for Project variable will be same for all SSIS packages inside a project. Thanks.
Hi Aqil sir,
5
I deployed ssis package on sql server 2019. Thereafter scheduled a sql job to run this ssis package weekly. When I started a job for the first time, it failed with following error.
Package execution on IS Server failed. Execution ID: 6, Execution Status:4. To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report Started
In the SSIS catalog, where you can see all deployed projects, right click on project name, go to reports and select All executions and you should be able to see all executions reports. Click on the failed execution and check the error message.
Hi Aqil sir, i created package for data move different server, source connection string Heidi SQL and destination server MySQL workbench but deployed package in SQL server 2019 successful &run
but jobs is failed
@@learner_SSIS What is the error message, I told you the steps to check the error logs from SSIS catalog deployed project.