dbTalk Databases Forums  

scheduled export

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss scheduled export in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
seeker53
 
Posts: n/a

Default scheduled export - 02-03-2005 , 03:39 PM






I would like an export to be sent to a user at the first of each day based on
a query. How is the best way to do this

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: scheduled export - 02-04-2005 , 12:22 AM






There are a few ways to do the export but seeing as this is a DTS group
then you could use DTS. The scheduling is done by SQL Server Agent.

"seeker53" <seeker53 (AT) discussions (DOT) microsoft.com> wrote

Quote:
I would like an export to be sent to a user at the first of each day based
on
a query. How is the best way to do this


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.