[SSIS.Pipeline] Error: component "Get open hours from SQL server" (64) failed the pre-execute phase and returned error code 0xC02092B4.

This is error you have.

Soultion is simple:

1. Setting NOCOUNT ON

2. Removing PRINT, CAST and CONVERT statements from the stored procedure

3. If u use temp tables inside the SP use SET FMTONLY OFF command