Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Run Command Line within package - But which Task? Expand / Collapse
Author
Message
Posted Friday, March 25, 2011 9:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:18 AM
Points: 150, Visits: 803
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,
Post #1084136
Posted Friday, March 25, 2011 10:33 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:26 AM
Points: 823, Visits: 1,203
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.
Post #1084184
Posted Monday, March 28, 2011 4:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:18 AM
Points: 150, Visits: 803
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.
Post #1084823
Posted Monday, March 28, 2011 4:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:09 AM
Points: 13,319, Visits: 10,182
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1084828
Posted Tuesday, March 29, 2011 8:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 19, 2014 12:57 PM
Points: 33, Visits: 38
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
Post #1085605
Posted Friday, June 27, 2014 2:21 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:20 AM
Points: 605, Visits: 1,412
...

it helps to talk it out
Post #1587034
Posted Friday, July 4, 2014 5:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 12:57 AM
Points: 66, Visits: 179
"Execute Process Task" is the best choise upto me..
Post #1589291
Posted Saturday, July 5, 2014 5:38 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:20 AM
Points: 605, Visits: 1,412
Yes Execute Process Task works great!

it helps to talk it out
Post #1589571
Posted Saturday, July 5, 2014 8:37 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 36,775, Visits: 31,230
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1589586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse