Page History: How can I keep a Package from timing out when executing a stored procedure?
Compare Page Revisions
Page Revision: 2007/12/17 20:18
Execute the stored procedure in a command line task (Step Properties - Advanced) with the following sytax:
SQLCMD -S.\PROVIDUSSTD -Q"EXEC DbName.dbo.StoredProcName" -Usa -Pvelocityscape