How can I keep a Package from timing out when executing a stored procedure?
Execute the stored procedure in a command line task (Step Properties -> Advanced) using the following syntax:
SQLCMD -S.\PROVIDUSSTD -Q"EXEC DbName.dbo.StoredProcName" -Usa -Pvelocityscape