i trying run ssis package sql server. able import package , run manually. able run manually ssis catalog. neither work agent job. oddly enough, when set package source sql server, package not show though listed in msdb folder.
account running job seems have permission , running ssms admin.
any ideas?
you using sql server 2012+ version, supports package deployment model. packages stored in integration service catalog. so, while creating job select package source ssis catalog (see screenshot below)
Comments
Post a Comment