"ChrisR" <bla@noemail.com> wrote in message
news:uzpwfbZyEHA.1524@TK2MSFTNGP09.phx.gbl...
> The problem though is that the file format of the file isn't constant. The
> people that send them to us rename columns, dont have the data the way
they
> really want it, etc. Thats why I need a GUI that isn't DTS.
>
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:#MRC2dWyEHA.3024@TK2MSFTNGP14.phx.gbl...
> > Hi
> >
> > I would write yourself a sceduled dts job that takes the file from a
> > specific location, processes it, and then archives it to a different
> > location. Therefore the only thing the user will have to do is move the
> file
> > into the location where it will be processed. See
> > http://www.sqldts.com/default.aspx?246 If you are wanting to cut out the
> > middle man totally you could use SQLMail and xp_readmail to recieve the
> > file.
> >
> > John
> >
> >
> > "ChrisR" <bla@noemail.com> wrote in message
> > news:en0uVgVyEHA.3024@TK2MSFTNGP14.phx.gbl...
> > >I need to give the ability to only somewhat technically minded people
to
> > > insert/ update into 1 SQL table. They have data that comes in
frequently
> > > from Excel files that needs to be imported and we want to make it so
> they
> > > don't need IT. There's no way to install just DTS without installing
> > > Enterprise Manager so thats out. Is there another tool?
> > >
> > > --
> > > SQL2K SP3
> > >
> > > TIA, ChrisR
> > >
> > >
> >
> >
>
>