DTS or Stored Procs?
(SQL Server) Keywords: no keywords
I need to import some data each night. I'll need to do a few compares to decide what data does and doesnt get imported.
I'd like to do this with a stored procedure because that's what I feel will be the fastest way to do it but I feel guilty for not using DTS. It seems like thats the standard for this type of import but I'd get the job done faster if I used a stored procedure instead of creating that same routine using a GUI/DTS.
What do you think?