Web Scraper and Web Macros FAQs
Navigation
Home
All Pages
Categories
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
How can I keep a Package from timing out when executing a stored procedure?
Print
RSS
Modified: 2008/01/31 16:55 by
craig
- Categorized as:
Database Connections
,
Package
,
Performance Related
,
SQL
(10)
»
Where are my downloaded files, templates, etc...
»
Automate export to a text file
»
How can I keep a Package from timing out when executing a stored procedure?
[X]
»
How do I transfer all packages and datapages to a new machine?
»
How to Build a Package
»
How to upgrade to Web Scraper 5.5 or above?
»
Output to Excel is not working or is slow
»
Overlapping Tags message
»
The datapage wizard freezes and I cannot click Next
»
What are optional fields?
»
Where are my downloaded files, templates, etc...
»
Automate export to a text file
»
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
Create a Page
|
Administration
|
File Management
|
Login/Logout
|
Language Selection
|
Your Profile
|
Create Account