Make sure you select 'Microsoft DTS Runtime 1.0' in Tools --> Refereces...
'Sub to run a DTEXEC cmd to kick off an SSIS Package Dim strCmd As String strCmd = "dtexec /f ""C:\MyPackage.dtsx""" Call Shell(strCmd, 0)
Reference:
http://msdn.microsoft.com/en-us/library/ms162810.aspx