sql - SSIS Package not showing under MSDB file -


i running sql server 2008 r2 , after trial , error created package server agent executes on schedule, on test server. when move on production server - using ssms logged in sa - create package right clicking database , going tasks did in test.

when log integration services see folders including msdb folder, saved package isn't there. when go server agent , navigate package created it's there! fails when server agent runs it.

i trying eliminate running of package thing causing error. first time has used integration service on production server maybe there's setup step missed? how packages show in ssms under msdb folder on test database?


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -