Run Command Line within package - But which Task?

Question

Post reply

Run Command Line within package - But which Task?

DerbyNeal

Hall of Fame

Points: 3854
More actions
March 25, 2011 at 9:53 am

#237361

Hi,
I need to execute the following prompt from within SSIS, but I don't know how. This is the command line that we've received from our supplier:
E:\Supplier\Exe\TaskSched.exe /d:E /l:en /n:abc /XX /p: /hs:123456789 “KW Test.ptf”
where:
d = Supplier drive
l = language
n = login
XX = makes it completely modeless (XY = With a dialogue summarising what’s running)
p= Supplier password
hs = dongle to use
NOTE
We are also advised that:
1. The task to run is then at the end of the command line – it is in quotes because of the space in the name.
2. There is also another switch that we need to put on the command line, /hf:51 (this prevents the task from accidentally using another license).
Any ideas?
Thanks in advance,

Viewing 9 posts - 1 through 9 (of 9 total)

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

Dan.Humphries SSChampion Points: 12125 More actions · Answer 1

you should be able to run this with a system task in SSIS.

Dan

If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

DerbyNeal Hall of Fame Points: 3854 More actions · Answer 2

Can anyone else explain how I can achieve this within SSIS? (other than Dan Humphries)

Unfortunately, I can't find anything on the net to help.

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 3

DerbyNeal (3/28/2011)
Can anyone else explain how I can achieve this within SSIS? (other than Dan Humphries)
Unfortunately, I can't find anything on the net to help.

Use the Execute Process Task.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

chandanamukka SSC Journeyman Points: 77 More actions · Answer 4

You can use the SSIS "execute process task", it is sometimes tricky with arguments. Below is the is link from Microsoft, I hope this helps.

http://msdn.microsoft.com/en-us/library/ms178485(v=SQL.100).aspx

KoldCoffee SSCoach Points: 18971 More actions · Answer 5

KoldCoffee

SSCoach

Points: 18971

June 27, 2014 at 2:21 pm

#1725585

...

prabhu.st SSCrazy Points: 2583 More actions · Answer 6

"Execute Process Task" is the best choise upto me..

KoldCoffee SSCoach Points: 18971 More actions · Answer 7

KoldCoffee

SSCoach

Points: 18971

July 5, 2014 at 5:38 pm

#1727192

Yes Execute Process Task works great!:-D

Jeff Moden SSC Guru Points: 1004600 More actions Follow · Answer 8

DerbyNeal (3/25/2011)
Hi,
I need to execute the following prompt from within SSIS, but I don't know how. This is the command line that we've received from our supplier:
E:\Supplier\Exe\TaskSched.exe /d:E /l:en /n:abc /XX /p: /hs:123456789 “KW Test.ptf”
where:
d = Supplier drive
l = language
n = login
XX = makes it completely modeless (XY = With a dialogue summarising what’s running)
p= Supplier password
hs = dongle to use
NOTE
We are also advised that:
1. The task to run is then at the end of the command line – it is in quotes because of the space in the name.
2. There is also another switch that we need to put on the command line, /hf:51 (this prevents the task from accidentally using another license).
Any ideas?
Thanks in advance,

There is absolutely no way in hell that I'd allow a login and password in any code, never mind plain text and especially NOT for a task scheduler of any kind. I consider this a major security violation and would quit my job rather than allow it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Run Command Line within package - But which Task?

Cookies on SQLServerCentral