Solved

Script in DTS

Posted on 2004-09-06
3
175 Views
Last Modified: 2010-04-05
Is it possible to make scripting in DTS ?
Can you send me an example plaese.

Thank,

Sang-Do
0
Comment
Question by:PHD
  • 2
3 Comments
 
LVL 6

Author Comment

by:PHD
ID: 11990887
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
 
LVL 6

Expert Comment

by:bpana
ID: 11991153
it is possible through dtsrun utility.
0
 
LVL 6

Accepted Solution

by:
bpana earned 500 total points
ID: 11991182
you can use master..xp_cmdshell stored procedure:

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now