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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS

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 server
2. 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.
Go to Top of Page
   

- Advertisement -