Script in DTS

Is it possible to make scripting in DTS ?
Can you send me an example plaese.

Thank,

Sang-Do
LVL 6
PHDAsked:
Who is Participating?
 
bpanaCommented:
you can use master..xp_cmdshell stored procedure:

exec master..xp_cmdshell 'dtsrun /SServerName /UUserName /PPassword /NPackageName'
0
 
PHDAuthor Commented:
I Try to launch a DTS package that imports data from excel into sql server table maybe via a stored procedure or an sql command ... .

Is it possible ?

Sang-Do
0
 
bpanaCommented:
it is possible through dtsrun utility.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.