Start SSIS package on System startup/Logon by Windows Scheduled Task
•
• •
Create SSIS package having mechanism for master controller. Create a “Execute SSIS .bat” batch file.
Configure the command to execute SSIS package (Package.dtsx) in it as below: DTEXEC.EXE /F "C:\Documents and Settings\sikke\My Documents\Visual Studio 2008\Projects\Integration Services Project3\Integration Services Project3\Package.dtsx" Add schedule task as shown in screenshot below: (i.e. Start >> All Programs >> Accessories >> System Tools >> Scheduled Tasks)
•
doc_290100238.doc
•
• •
Create SSIS package having mechanism for master controller. Create a “Execute SSIS .bat” batch file.
Configure the command to execute SSIS package (Package.dtsx) in it as below: DTEXEC.EXE /F "C:\Documents and Settings\sikke\My Documents\Visual Studio 2008\Projects\Integration Services Project3\Integration Services Project3\Package.dtsx" Add schedule task as shown in screenshot below: (i.e. Start >> All Programs >> Accessories >> System Tools >> Scheduled Tasks)
•
doc_290100238.doc