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 |
Jaybee from his castle
Yak Posting Veteran
64 Posts |
Posted - 2004-04-19 : 11:14:57
|
Hi all,I was wondering if it were possible to automate the following processes:Have a DTS package unzip a winzipped csv file in my Outlook inbox, import the contents to a new table according to the existing layout of the csv (rather like the 'Select Into' command in SQL Server), and every subsequent day append the contents of a new, zipped csv (which will always have the same layout) into the database.I suspect it'd be simpler to manually import the first file, along with the in-process creation of the table, in advance of the first running of the package. The biggest problem I foresee is getting the package inside Outlook, which would keep the csv file in a .dbx file, I believe.I'd be grateful for some tips, and perhaps an overview of how I should go about this.Thanks in advance,JayBee |
|
|
|
|