Date: 03/11/05 (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?

Source: http://www.livejournal.com/community/sqlserver/21019.html