Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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