Solved

How to run a VBS script before deploying Package

Posted on 2008-10-29
8
436 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
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

Office 365 Training for IT Pros

Learn how to provision Office 365 tenants, synchronize your on-premise Active Directory, and implement Single Sign-On.

Question has a verified solution.

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

Suggested Solutions

Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack.  My needle was an anti-virus version causing problems with my Exchange server. I have an HP DL350 with Windows Server 2008 Stand…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

738 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