This project is read-only.

Set timeout on Setup etl-run

Dec 3, 2014 at 1:54 AM
I have a setup step that runs a SSIS package

<setup>
  <etl-run server ="localhost" catalog="SSISDB" folder="Folder" project="MyProject" name="package.dtsx"  />
</setup>
There seems to be a 30 second timeout where it will stop the process after 30seconds. Is there a way extend this timeout?
Dec 3, 2014 at 8:16 AM
Unfortunaletly, there is no solution at the moment. The reason for this is because the Microsoft.SqlServer.Management.IntegrationServices.dll assembly is simply using a SqlCommand object, which has a default timeout of 30 seconds, to call the SSIS catalog stored procedures. Unfortunately the assembly doesn’t provide any way to get at the timeout property.

But I should be able to write my own wrapper on top of the internal stored procedures of the SSISCatalog and override this. I'll be looking to this in the next weeks.
Dec 3, 2014 at 8:41 AM
ok, that makes sense. In the meantime I am going to try changing it into a SQL script and execute the package manually using the SSISDB stored procedures, then looping to check that it has completed so that the step is performed synchronously.
Dec 23, 2014 at 4:38 PM
Edited Dec 23, 2014 at 5:34 PM
The Work Item 54 is referring this feature and your feedback is welcome.
Marked as answer by Seddryck on 2/12/2015 at 1:38 PM