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 |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2009-07-28 : 11:28:37
|
| Hi GuysAt present we have an email containing a csv file that is sent to company mailbox once a day. We import the data from the email into SQL database, which is usually done through saving the attachment to somewhere on the network and then import it into the database using the import/export wizard.Is it possible using SSIS to save this attachment to a location automatically as soon as the email arrives? From this I will be able to import the data using another SSIS package.We are currently using the exchange server for our emails.Thanks |
|
|
|
|
|
Email Attachments