sql server - Running SSIS job using Windows task scheduler -


i new world of etl. started using ssis , have come across couple of questions on this.

1.can run ssis package using windows task scheduler? 2. if above answer yes,i don't have ssms installed on machine. can ssis package run in absence of ssms?(i have visual studio , sql server data tools installed) 3. can ssis package run in absence of visual studio , sql server data tools.say example, create ssis package , remove visual studio , sql server data tools machine. task scheduler still able run ssis package? 

thank in advance.

you can run ssis job command prompt through dtexec utility check query

dtexec /f /set \package.variables[variable]; value

example:- dtexec /f e:\test_package\test_package\package.dtsx /set \package.variables[id];1

reference:- methods execute ssis package


Comments