I need a solution for the error I am getting in my SSIS package.
For the SQL Execute Task I am running a stored procedure.
If it takes longer than 30 seconds the task fails.
I have already tried splitting the process into four tasks but it fails about every other time.
I have read there is no fix for this because the timeout option does not work.
I need some other solution for how to run my project. I am querying data to pull into an XML file and then ftp the file.
failed with the following error: "Query timeout expired".