R
Roy
Could someone point me in the right direction here?
The current method of importing new data into our db
goes something like this:
1.) txt files received via email
2.) employees clean data and save it in Access
3.) they import it into sql server using a dts package
It's a legacy process that could be updated...which is
where I come in. In about 2 weeks the employees who
do this work will be moved to an off-site location.
Since our network on-site is very secure, they will
have no method of "telecommuting" or VPN'ing into
the intranet to access sql server or anything.
My thought is this: have them continue doing steps 1
and 2 at the off-site office, but give them some
web front-end using which they could upload the new
data remotely into sql server (before you ask, network
security prevents them from simply logging into sql
server remotely using Enterprise Manager). I'm thinking
XML? But I'm unsure. I've never done anything like
this before and I don't want to waste time rabbit-trailing
down unproductive avenues. Anyone have any links or
insights?
Thanks!
The current method of importing new data into our db
goes something like this:
1.) txt files received via email
2.) employees clean data and save it in Access
3.) they import it into sql server using a dts package
It's a legacy process that could be updated...which is
where I come in. In about 2 weeks the employees who
do this work will be moved to an off-site location.
Since our network on-site is very secure, they will
have no method of "telecommuting" or VPN'ing into
the intranet to access sql server or anything.
My thought is this: have them continue doing steps 1
and 2 at the off-site office, but give them some
web front-end using which they could upload the new
data remotely into sql server (before you ask, network
security prevents them from simply logging into sql
server remotely using Enterprise Manager). I'm thinking
XML? But I'm unsure. I've never done anything like
this before and I don't want to waste time rabbit-trailing
down unproductive avenues. Anyone have any links or
insights?
Thanks!