Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Run DTS From Access adp??
Message
De
15/12/2004 07:58:28
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00968737
Message ID:
00969397
Vues:
10
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform