Removed

Your Question has nothing to do with the thread to which it is attached. If you want to get a response that is pertinent to your question, I would suggest...

umertahir (10/20/2009)

---

I have a very simple script which imports multiple excel files into a SQl table:

USE [Landcatch]

DECLARE @archivePath VARCHAR(500), @templateFolder VARCHAR(100), @cmd NVARCHAR(4000);

SELECT @archivePath = 'C:\', -- Excel file path...

One benefit is that the Certificate and certificate user account are managed outside of the stored procedure code and can be updated or the user account changed without having to...

Great Article!

I have a couple of suggestions to make the stored proc more flexible.

1.Make the certificate name and certificate user name parameters so that it could be used for...