dts alternative?

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, ChrisRHi
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
>|||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...
they[vbcol=seagreen]
>|||Chris,
There are numerous third-party data transformation products available...
Here's one that I have not used before but that looks pretty interesting
based on the website:
http://www.idera.com/Products/DTx/Default.aspx
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"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...
> file
to[vbcol=seagreen]
frequently[vbcol=seagreen]
> they
>|||How about a simple .net app?
If you use a datagrid then the users should be able to copy the contents of
the spreadsheet into the grid, click a button to import.
I have a system where the users put the data into a spreadsheet then a macro
does the copy to a table and am planning to replace it with the above. Shoul
d
only take a few hours to write so sometime middle of next year I guess .
"ChrisR" wrote:

> 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
>
>