Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Run DTS From Access adp??
Message
From
15/12/2004 07:58:28
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00968737
Message ID:
00969397
Views:
11
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform