Hi All,
How do i run a sql 2005 SSIS package (dtsx) file system under windows event/task schedular, with the "execute" button being pressed automatically?
I have created SSIS package and want to schedule to run on daily basis. I can schedule this package on SQL Server Agent but the server that i am working on it DOES NOT have SQL Server Agent so, after doing some GOOGLE search found out that "YOU CAN RUN .dtsx by using window schedule task".
I scheduled a .dtsxpkg but what it does it open SSIS package window and ask the user to click on "Execute" button on right hand side.
Can any one tell me how to schedule .dtsx file on window schedule task to execute on daily basis? Also, I am doing remotely, i have access to database server directly so, please advice,
Thank You,