Ways to automate SSIS packages -


i have ssis package needs run daily. needs excel execute active tasks in package. cannot install excel in sql server have, cannot create sql job run ssis package. there other options automate ssis packages?

you don't need install excel on sql server in order use excel source or destination. do, however, need box clever.

i'd recommend project deployment ssisdb. use sql agent schedule. within sql agent job step --> configuration --> advanced , click on 32-bit runtime.

enter image description here


Comments

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -