SQL Server 2008 R2 I have created a package in SSIS that works perfectly. I am now trying to schedule it to run on a daily basis via a SQL Server Agent Job. When I create a new job and set the type to "SQL Server Integration Services Package" it only sees two of my packages. Those two are not the one I need to run. I have tried creating a new project and package in SSIS. However my job does not see it either. How do I get my package to show up as a selectable option? Thanks, Scott

Where are the packages that you are trying to run? Are they stored in SQL server or are they in the file system?Chuck

As Oldjeep says where are the packages stored. when you develop a package with BIDS you have to deploy it first with SSMS on an Integration services server. Then SQL server Agent job setup can list these. Scheduling jobs to run packages in your development environment is not a good idea, unless you plan on never ever changing the packages. Jan D'Hondt - Database and .NET development

Hi Scott_Hanebutt1, It seems that you cannot find the SSIS package that you have created, just as Chunk said, where you save the package? SQL Server, File System or SSIS package Store? For more information about it, please see: http://thebipalace.wordpress.com/tag/ssis-package-store/ http://sqlsafety.blogspot.com/2010/10/package-storage-msdb-folder-or-package.html Thanks, Eileen