October 2, 2006 at 6:46 am
Hi
Our clients mail us excel sheet and we need to convert that sheet into a sql server 2000 table. How can i run DTS Package so that it will check file name and append data in a table. it can be weekly,daily or monthly.I want to pick that file directly from mail.Is it possible to do with activex or DTS.
Regards
October 3, 2006 at 7:47 am
I did this for a project once. The data file we needed was distributed via internal e-mail and they would not consider FTP or a networked storage location. I had our mail server admin create a special mailbox just for this task and then used an ActiveX script in a DTS package to open the mailbox, search for the message, and save the spreadsheet to a temporary location. Once that was done, it was a simple import task.
I'm not sure what you're using for mail; that office used GroupWise, so I had to install an API on the database server for this to work.
--Andrew
October 6, 2006 at 5:31 am
Thanks Andrew
We are also using internal e-mail. Could you provide activeX code for this task.
Regards
October 6, 2006 at 3:09 pm
I don't have access to that system anymore, and not knowing whether you are using Outlook/Exchange, GroupWise, etc., I don't know how applicable the code would be anyway.
I put a couple links here for more general information on accessing mailboxes that will work in ActiveX script. In any event, you should be able to search for the message you need and save the file attachment to a location where you can reach it to import.
Outlook/Exchange Server:
http://www.outlookexchange.com/articles/glenscales/attacharc3.asp
(You can also search for MAPI or CDO.)
Novell GroupWise:
http://forge.novell.com/modules/xfmod/project/?gwobjapi
Hope this at least gets you started.
--Andrew
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply