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.
Comments
Post a Comment