 | |
help on email the exported results through DTS (SQL2K5)
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: help on email the exported results through DTS (SQL2K5) -
07-18-2008
, 10:38 AM
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
#12
| |||
| |||
|
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
#13
| |||
| |||
|
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
#14
| |||
| |||
|
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
#15
| |||
| |||
|
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
#16
| |||
| |||
|
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
#17
| |||
| |||
|
|
On Jul 18, 3:51 pm, sg <s... (AT) discussions (DOT) microsoft.com> wrote: Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a lot, Sarah Yes it is. You can either use Send Mail Task (and you must have Outlook installed on your dbserver) or script with activeX for sending it with SMTP (ain't really sure about it) or again use scripting to dynamically build a .BAT for sending your attachment with a free command line program like: http://www.blat.net http://sourceforge.net/project/showf...group_id=81910 HTH M. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.