I have used following code to execute DTS package from VB.
The problem I am having is, that it works fine from some pc but not with others. For example it gives me error of %1 not found, but on DBO'S machine it works fine. I have SQL 7 and he has SQL 2000.
I am new at VB so please give details/more explanations or references.


Private Sub RunPackage()

'*************Code to execute DTS Package*********
'Run DTS Package to create temptbl

Dim oPKG As DTS.Package, oStep As DTS.Step, oTask As DTS.Task
Set oPKG = New DTS.Package

oPKG.LoadFromSQLServer "SERVER IP ADDR", "DATABASEUSERID", "DATABASE PASSWORD", _
DTSSQLStgFlag_Default, "package password", , , "package name"


' Set Exec on Main Thread
oPKG.Execute

Set oPKG = Nothing
'*************End of Code to execute DTS Package*********
End Sub