Running SSIS Package from SQL Server

1
votes

I am trying to run an SSIS package from SQL Server. I was able to successfully import the package and run it manually. I was also able to run it manually from the SSIS Catalog. Neither work from the agent job. Oddly enough, when I set package source to sql server, the package does not show even though it is listed in the MSDB folder.

Account I am running the job from seems to have permission and I am running SSMS as admin.

Any ideas?

1
sqlsql-serverssispermissions
Can you paste code and screen shots? – Tom Stickel
Is the job schedule executing and erroring, or not executing? – Greg Viers
Do you have environment variables defined? – Greg Viers
What's the error you're getting? – Zane
Run SELECT 'Found in SSISDB', * FROM SSISDB.catalog.folders AS F INNER JOIN SSISDB.catalog.projects AS P ON P.folder_id = F.folder_id INNER JOIN SSISDB.catalog.packages AS PKG ON PKG.project_id = P.project_id WHERE PKG.name LIKE '%MYPackageName%' or this query and let us know which one listed the package you are trying to run – billinkc

1 Answers

1
votes

You are using SQL Server 2012+ version, which supports package deployment model. Packages get stored in Integration service catalog. So, while creating job select package source as SSIS catalog (see screenshot below)

enter image description here