How to troubleshoot production package outside of SSISDB framework
Could anyone please answer the above question. This is recent interview question.
See also questions close to this topic
Cube not running the update from DTSX
I create a DTSX package to update data in a database and then to run the DIMENSIONS and CUBE. If I run the cube directly in Visual Studio or if I process manually the dimensions and the cube, everything works correctly.
The problem is when I create a job in SQL Server Agent to run the DTSX. The job finish without problem, the data is updated in the database but the cube and dimensions aren't updated.
Utilidad de ejecuci¢n de paquetes de Microsoft (R) SQL Server Version 14.0.1000.169 for 64-bit Copyright (C) 2017 Microsoft. Todos los derechos reservados.
Iniciado: 12:38:13 DTExec: la ejecuci¢n del paquete devolvi¢ DTSER_SUCCESS (0). Iniciado: 12:38:13 Finalizado: 12:39:56 Transcurrido: 102.61 segundos
Azure Data Factory (SSIS) Execution Using Integration Runtime Throws "Unexpected Termination"
I have been using Azure Data Factory V2 for a while to execute SSIS packages from the SSISDB catalouges. Today (16-11-2018) I have encountered "Unexpected Termination" Failure message without any Warning and Error message.
Things than I have done:
- Executing the SSIS package manually from the SSISDB catalogue in SQL Server Management Services (SSMS). What i have noticed is that it took an exceptionally long time to assign the task to a machine. When the package is assigned to a machine, within 1 or two minutes it throws back the Failure message.
- There are 3 SSIS packages that is excecuted "sequentially" with the Azure Data Factory Pipeline. Often the 1st package is executed successfully, however the 2nd and 3rd package never succeded.
- Another error message that I got is "Failed pull task from SSISDB, please check if SSISDB has exceeded its limit".
I hope anyone can help me with this issue. I have been searching the web and could not find anything on this subject.
SSIS Package, execute every 13 hours for previous 12 hours of data
I have a SSIS Package and I need to schedule it to run at
1:00 PMevery day.
1:00 AMit should pass parameters of the previous day for e.g.
15 Nov 2018 12:00 PMas
15 Nov 2018 11:59 PMas
1:00 PMit should pass parameters of the current day for e.g.
15 Nov 12:00 AMas
15 Nov 11:59 AMas
A stored procedure is called through an OLE DB Source Editor task in Data Flow.
Does anyone have any suggestions that How I could achieve this noting the fact that if the job fails at
1:00 PM& it should re-run at
2:00 PM, it should still pass the same parameters.