>-----Original Message-----
>I did a quick ggogle and this looks promising
>
>http://groups.google.com/groups?q=automate%20attachment%
20outlook%20save&hl=en&lr=&ie=UTF-8&oe=UTF-8&sa=N&tab=wg
>
>--
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.SQLDTS.com - The site for all your DTS needs.
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>
>"Jason" <anonymous@discussions.microsoft.com> wrote in
message
>news:6ae901c42ec5$7c025860$a101280a@phx.gbl...
>> Yes, it will be an attachment. Actually two .csv
>> attachments. Could you point me to a site where there
>> may be a tutorial on this? Thanks.
>> >-----Original Message-----
>> >Will they be sending the data as an attachment?
>> >
>> >If yes then can you
>> >
>> >Filter the messages containing the data into a given
>> mail folder
>> >use the Outlook object model and check for the
attachment
>> >Save the attachment out to a folder on the file
system.
>> >Have the DTS package look inside this folder
>> >
>> >
>> >
>> >--
>> >--
>> >
>> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> >www.SQLDTS.com - The site for all your DTS needs.
>> >I support PASS - the definitive, global community
>> >for SQL Server professionals - http://www.sqlpass.org
>> >
>> >
>> >"Jason" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:6a8301c42ebc$d5637190$a101280a@phx.gbl...
>> >> I work with a client who provides me daily updates
of
>> >> data on their FTP site. I created a DTS package to
>> load
>> >> this data on a nightly basis.
>> >>
>> >> Now they will be sending a weekly email with some
other
>> >> data that I will be responsible for inserting into
our
>> >> SQL 2000 DB. For whatever reason they cannot post
to
>> an
>> >> ftp site.
>> >>
>> >> So, I would like to automate a process that will
insert
>> >> the data from the file in the email attachment. Is
>> this
>> >> possible? Or, is there an easier way to automate?
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.