Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Execute different commands using ADO

Status
Not open for further replies.
mc81773

mc81773

Programmer
Sep 19, 2002
6
US
I am using DTS in SQL Server 2000.
Inside DTS,using VB scripting modules I am trying to do the following:
1. Insert into ERRORLOG table.
ERRORNUM varchar(5)
ERRORdet varchar(50)


2. Execute a stored procedure.
SQL Server : Server1.aaa.com
UserID : mysuser
Password : mypass
Database : PYMT1
Stored Proc : myproc1

Can Anyone give me a template to do this.
 
Status
Not open for further replies.

Similar threads

Palito1916
  • Locked
  • Question
Disable multiple computer accounts using TXT file with computer names
Replies
2
Views
275
Palito1916
Palito1916
elly00
  • Locked
  • Question
execute sql store prodecure
Replies
1
Views
136
SaltyTheFrog
SaltyTheFrog
EdScripts
  • Locked
  • Question
Using a Variable in the Run Method - I would sure like to be able to do this !
Replies
0
Views
182
EdScripts
EdScripts
queen_mszdia
  • Locked
  • Question
invoke runas different user from inside VbScript
Replies
0
Views
178
queen_mszdia
queen_mszdia
Gouli
  • Locked
  • Question
Vbscript I want you to execute a command in cmd
Replies
1
Views
166
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top