| Author |
Topic |
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
 Posted - 2009-02-24 : 10:23:13
|
| Hi,I'm in the process of doing an automation...and as one of the steps..I will have to read an email and with that data do an update on a table.I have never done this before. Is this possible in SSIS. If yes, which task in the Control flow should I be using to read an email directly? (I only see a Send EMail task??) |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-24 : 11:16:00
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105257 |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-24 : 11:59:13
|
| Yosiasz...thanks...but whatever I'm looking for is not an attachment. If its an attachment , I can have it passed thru FTP..the data I need is the actual mail content..which comes in a specific format. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 12:45:54
|
| i think what you can do is to make use of expression builder and get the email body content onto a local variable created in package. then use a execute sql task to insert value from variable onto table. |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-24 : 13:09:34
|
| Visakh...thanks for your post...but I'm a li'l confused. Can I use expression builder to read the e-mail as well. Or is it just to assign the email content to the variable that i define? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-24 : 13:19:34
|
| or you cna change your process and have whomever is sending you the email to post it to your fpt? Is that possible. Then you are free from email account. what is the content of the email, show us the content if possible. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-24 : 13:24:11
|
| This is the content yosiasz.. Hi, CDPFILE is ready for processing Cycle Code : D0918E Date : 02/24/2009ONce this mail is received, I will have to update a Batch Start table with the date and cycle code and then the batch run uses this date and cycle code for today's processing.This is being done manually now. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-24 : 14:00:23
|
| what is the course of that data sent to you by email? a database , a calculation done by a user using calculator? An Access database, an Excel spreadsheet...what if tomorrow a new person is hired and they change Cycle Code to CC and Date to Dt...It is manual entry in the email so it is volatile. I was thinking maybe there is a better way than email. can please answer questions above? |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-24 : 14:30:07
|
| Yeah sure I can..This e-mail is generated by one of the interfacing systems which provides us with a feed file.This e-mail is a system generated e-mail which is produced by a mainframe JCL job...hence the format will not change. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-24 : 14:36:21
|
| so it generates both an email and a feed file? is the feed file identical to the content of the email?see where I am geeting @ |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-24 : 14:42:56
|
| better yet can you have the JCL job produce an xml or txt file or whatever in addition or instead of an email? |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-24 : 15:02:02
|
| I get your point. I will try to ask our Interface partners change their JCL to see if they can FTP that content in some other way...thanks for all yur help. |
|
|
|
|
Read Mail and Update Table