Create Job for SSIS
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
May 10th, 2012 5:00pm

Where are the packages that you are trying to run? Are they stored in SQL server or are they in the file system?Chuck
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 5:01pm

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
May 10th, 2012 5:05pm

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: Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 6:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics