how to call a dts from stored proc

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

woast SSC Journeyman Points: 87 More actions · Answer 1

EXEC master..xp_cmdshell 'DTSRun /S "(local)" /N "PREPROCESSING_DICTIONARY import" /W "0" /E'

read help info on xp_cmdshell and DTSRun

command line utility dtsrunui offers a gui to build the above string and export it, so you don't have to figure out all the syntax

fred2002 SSCrazy Points: 2943 More actions · Answer 2

hello woast,

thank you, it seems to work........