Mass Uploading temp data

Last Post 20 Jan 2007 06:56 PM by dianagele. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dianagele
New Member
New Member

--
07 Jan 2007 08:02 PM
I can have an Admin upload mass-data with this tool:
http://www.convert-in.com/xls2mss.htm

I use the only use the local instance for our admins to mass-upload.

Then I use SSIS to push n pull..

dianagele
New Member
New Member

--
20 Jan 2007 06:56 PM
Good questions. Simple wizard interface for night-time Administrative Assistants to use.

We have curious Admins (Administrative Assistants); we can let them use this tool to port over temporary tables -- their man-hours to upload alleviate our "dirty duity"and $
doubling up work? Not really; these night crew Administrative Assistants are ferreting over information at a fast rate. Easier for the db people to suck it up from a temp table..

(we don't want them getting into our environment & helps our jobs when we come in the AM & we have our data waiting for us.) YAY
We have limited policy with linked servers in 2000 -- but now have gone to SQL SERVER 2005; policy may change!
You are not authorized to post a reply.

Acceptable Use Policy