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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-09-13 : 16:10:19
|
| Today, my customers deliver "user" updates with emailed csv files. I use DTS to import these files into a table 'import' then execute a procedure which then sorts and integrates these updates into the database..The customer gets the imports from an oracle database. I'd like to know what recommendations there might be to enable the customer with a secure mechanism (with unique username/pwd) so the customer could automate the transfer of the data from his oracle database to my sql 2000 table?SamC |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-13 : 17:03:07
|
| DTS. If they can provide a VPN connection or just an open port to the Oracle server you can write a DTS package to grab the data directly. I've done it a few times between VA, NY and CA and it worked great. They could even push the data to you using DTS on their end, they could download the trial version of SQL Server and install it, the DTS components will still work after the trial period ends. You would have to provide an open port to your SQL Server for them to do that though. |
 |
|
|
|
|
|
Customer wants access to automate imports