Executing an SISS package through autoit

[Mian]

I wrote the following script. I have similar scripts to open internet explorer and excel when the user is not logged in and they work fine. The following script which opens an SSIS package and execute it is working fine when the user is logged in but stop working when the user is logged off. It stops after opening the SSIS package. I dont know why controlsend is working in the other two scripts but not in this one. Please help.

 

expandcollapse popup

ShellExecute("C:\Users\xyz\Desktop\exescripts\PackageToUploadDataToSqlServer.dtsx")
sleep(5000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(500)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(500)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(500)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(500)
ControlSend("Execute Package Utility", "", "", "{ENTER}")
sleep(50000)
ControlSend("Package Execution Progress", "", "", "{TAB}")
sleep(1000)
ControlSend("Package Execution Progress", "", "", "{ENTER}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{TAB}")
sleep(1000)
ControlSend("Execute Package Utility", "", "", "{ENTER}")
sleep(1000)


Exit

 

[topten]

Try to get the class of the window with autoit info tool and get handle of the window title

$hWnd = WinWait("[Here is class of your program process]", "Execute Package Utility", 2)

$process = WinGetHandle(WinGetTitle($hWnd2))

ControlSend($process, "", "[CLASS......]", "{tab}")

 

[Mian]

Thanks for the tip, I will try it.

I also found that there is a command line utility DTexec.exe, which can run the SSIS package from commandline. I created the batch script and added it to the task scheduler.