August 25, 2008 at 12:48 pm
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?
August 26, 2008 at 8:40 pm
Your question is not very clear.
Are you importing the records to a table?
What have you tried so far...?
If you want please elaborate, or take a look at this, it might help you to get started:
http://dotnetslackers.com/articles/sql/UsingSQLServerIntegrationServicesSSIS.aspx
~Jay
August 26, 2008 at 10:00 pm
Thanks Jay
Entire Process should work like this.
1. Need to create a txt file with certain login information from the database and FTP to this txt file to FTP server on daily basis
2. Around 5 a.m FTP server wll generate text file and i need to pick up those text file and create a new text file with some information present in the text file (FTP location) and email them to different user.
Hope i am clear. I have done the first part of FTP text file to FTP server.
Need to second part.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply