[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

Script in DTS

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

Thank,

Sang-Do
0
PHD
Asked:
PHD
  • 2
1 Solution
 
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
 
bpanaCommented:
you can use master..xp_cmdshell stored procedure:

exec master..xp_cmdshell 'dtsrun /SServerName /UUserName /PPassword /NPackageName'
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now