Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
keywest
Starting Member
3 Posts |
Posted - 2008-08-25 : 14:54:57
|
1. i have a huge text file present in mainframe fTP server2. i have get certain information from the text file and send email to corresponding people on daily basis.How do i do it? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-26 : 00:12:15
|
use data flow task with file source connection to get source data. there are lots of tasks like derived column,type conversion etc if you want to transform source data. Finally you could use send mail task to send mail to people. |
 |
|
|
|
|