Solved

How to run a VBS script before deploying Package

Posted on 2008-10-29
8
433 Views
Last Modified: 2013-11-21
I have a simple VBS script (copies a file on the network to a local client - easy stuff) and want this script to run right before or after the package installs.  This script can only be run for a specific package, and I don't care if it runs before or after the package installs.  

Under 'program properties' for the program, on the 'Advanced' tab is an option to 'Run Another Program First.'  I can select a package, but how can I make a package out of a VBS script?  Do I just create a new package with 'xxx.vbs' in the CMD line, and no switches?  Run as hidden?
0
Comment
Question by:NBquery
  • 4
  • 2
  • 2
8 Comments
 
LVL 18

Expert Comment

by:Americom
ID: 22836610
What you need to do is create another package in SMS for your VBS script, yes run Hidden. On your other package you have created just like you said in the Program properties for that program, on the Advanced tab, check the "Run another program first". Then right under that, click on the drop down botton on the right side of Package and select the package you created for the VBS script. That's all you need. When you deploy your program package, it will run the VBS first then the program installation of your package.
0
 

Author Comment

by:NBquery
ID: 22837639
Well, I got the package created in SMS, but it doesn't seem to be working.  I have it set as 'Hidden' and in the CMD line of the program:
'script.vbs'

There are no switches or arguments on the CMD line, just the vbs name.  Is there something else I ned to include on the CMD line?  The status manager is reporting a successful install, but its not doing anything.
0
 
LVL 5

Accepted Solution

by:
DecKen earned 250 total points
ID: 22838863
try changing the command line of your VB script package to
cscript script.vbs
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 18

Expert Comment

by:Americom
ID: 22840425
Won't hurt to try cscript...
btw, did you just type the script.vbs in the command line when configuring the package? If so, make sure you use browse to find the script.vbs instead of manually typing it in. Where ever the path of this script.vbs, try run it from the path manually from your SMS server to verify it is working through the path and security, assuming the account you use also have the same permission as the SMS Admin account you use that have access to all servers resources. Also, you can change the Hidden to Maximized to see if it's doing anything.
0
 

Author Comment

by:NBquery
ID: 22864587
Weill, that's not working really.  I ran the script on the sms server and it copied the file I specified in the script from the remote server, to the local Windows directory.

Not sure whats going wrong.  He is the vb script I'm using:

DIM objFSO, sFile, strComputer
'On Error Resume Next
'sFile="c:\windows\saplogon.ini"
set objFSO=createobject("scripting.FilesystemObject")
'if objFSO.fileexists(sFile)=true then
'else
  objFSO.CopyFile "\\dcdfs11\AllAccess\logon.ini", "c:\windows\"
'End if
Wscript.quit

Can anyone see a issue with the above script, whats causing it to flake out on me?  I have tried setting the package CMD line to 'cscript script.vbs' and also 'script.vbs' on its own.
0
 
LVL 5

Expert Comment

by:DecKen
ID: 22865292
When you run the script via SMS by default its going to use the system account unless you set it to run as a different account.
Check the access to \\dcdfs11\AllAccess\logon.ini does everyone have access to the file?
0
 

Author Comment

by:NBquery
ID: 22866926
Yes, everyone at the company has read access to that directory.  SMS is running the program with Administrator rights.
0
 

Author Closing Comment

by:NBquery
ID: 31511246
Unfortunately, this script did not run but we cannot tell if its due to SMS or our networking environment.  Still pretty good suggestion.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 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