Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

SSIS 2005 - How to schedule a new job

Hi and thanks,

I have created a SSIS 2005 package
This package executes fine.

I would like to schedule this package to run at set times.

I have done some reading using:
http://www.mssqltips.com/sqlservertip/1775/different-ways-to-execute-a-sql-server-ssis-package/

But this does not seem to match what I have this is what comes up under SSMS - SQL Server Agent Job (see attachment):

If you notice the options are different and no where do I see an option for the SSIS package?

What am I doing wrong?
Is there a different Agent that I should be going into?
Should I be using SSMS to schedule/call a SSIS?

Thanks
SQLAgent.docx
0
Amour22015
Asked:
Amour22015
  • 2
  • 2
2 Solutions
 
Jesus RodriguezIT ManagerCommented:
I suggest you something easy. Create an store procedure that run the package and schedule the store procedure.
0
 
Jesus RodriguezIT ManagerCommented:
Something like this on the store procedure

BEGIN
  SET NOCOUNT ON;
  EXEC xp_cmdshell 'DTExec /SER YourSqlServer /PackageFolder "PackageName"'
END
0
 
tim_csCommented:
You need to go to the "Steps" page of the job and add a new step.  This is where you will see the options to pick a package.
0
 
Amour22015Author Commented:
Hi and thanks,

k-designers, has a good idea, but I want to use the server agent and SSIS

tim_cs, thank you that is what I am looking for, but because of k-designers post I am giving some points to be fair...
0
 
Amour22015Author Commented:
Thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now