How can I keep a Package from timing out when executing a stored procedure?

Modified: 2008/01/31 16:55 by craig - Categorized as: Database Connections, Package, Performance Related, SQL

» Using Excel as input to a package. » In the datapage my extraction works, but it fails in a package. » 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

Web Scraper and Web Macros FAQs

Navigation

How can I keep a Package from timing out when executing a stored procedure?