I have looked through the material from your link Sergey (thank you), and it may be more than I need. I just need to get a DTS module to run. I have tried to create a stored proceedure (which I can envoke from Access):
CREATE PROCEDURE DTSTest AS
EXEC dtsrun /S 'MyServer' /U 'DTSUser' /P 'UserPasswd' /N 'DTSName' /M 'DTSPasswd'
GO
I get the error 'Error 170: Line 3: Incorrect syntax near '/''.
This syntax is as correct as I can find in the documentation. Does anyone know what I am doing wrong? Any help is appriciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.