[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

DTS Package or any means to run a stored proc and schedule output in SQL Sever 2005

I have a stored proc that i would like to run automatically and schedule an output of a file in csv format and drop it to a directory. This is in SQL Server 2005.
0
tomasdlv
Asked:
tomasdlv
1 Solution
 
SQL_SERVER_DBACommented:
just create a package using Integration Services, should have come along with your SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms141209.aspx
0
 
tomasdlvAuthor Commented:
in the wizard how can i make it accept a stored proc instead of a sql statement. it seems to only want select statements
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now