Hi,
I am looking to create an excel file(append today's date to it) from OLE Db source. And send out an email with this file as attachment. (Note that this excel file will be created everyday. so when this job gets run everyday, it should send the newly created(today's file) in the attachment). I am not sure on how to create an excel filename with today's date and how to use this in the attachment. If someone can help out, it would be really appreaciated.
Thanks in advance.
I am looking to create an excel file(append today's date to it) from OLE Db source. And send out an email with this file as attachment. (Note that this excel file will be created everyday. so when this job gets run everyday, it should send the newly created(today's file) in the attachment). I am not sure on how to create an excel filename with today's date and how to use this in the attachment. If someone can help out, it would be really appreaciated.
Thanks in advance.