Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
| Search | Today's Posts | Mark Forums Read
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 29th, 2006, 11:59 PM
Registered User
 
Join Date: Jan 2006
Location: , IA, .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Scheduling DTS task on SQL Server 2005

I am a relative newbie to SQL Server 2005. I have gone through the process of migrating my packages to 2005. My question is this. How do I schedule the package to execute at a specific time through SQL Server 2005?

  #2 (permalink)  
Old February 4th, 2006, 02:38 AM
Registered User
 
Join Date: Feb 2006
Location: Male, Mafannu, Maldives.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dont you have somthing called scheduling in SQL 2k5. Personally, i havent been able to play arnd with sql 2k5, but in sql 2k, there's scheduling jobs. I am sure the same/better, must be in sql 2k5.

Check books online or something.

cheers

NOthing is impossible if you dare to.
  #3 (permalink)  
Old February 7th, 2006, 12:25 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

Since you have migrated your packages it is safe to say that they are then SSIS packages and they are stored in the SQL Server.
Create a job, Create a new job step. Select SQL Server Integration Services package execution as the job step type.
For more info see 2005 BOL topic: How to: Run a Package Using a SQL Server Agent Job

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
  #4 (permalink)  
Old February 7th, 2006, 12:40 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

Alternatively you can create a job step of type Operating System (cmdExec) use the dtexec command line tool

If it is a DTS (SQL 2000) Package then you can create a job step of type Operating System (cmdExec) and then use the dtsrun.exe command line tool (see SQL 2000 BOL for info about its parameters)

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
  #5 (permalink)  
Old March 29th, 2006, 01:51 PM
Registered User
 
Join Date: Mar 2004
Location: Swanzey, NH, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to badercheema
Default

Use Job steps in SQL Management Studio to schedule a SSIS package. Also make sure that SSIS service is installed and running otherwise you will get an error.

Bader Cheema


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in accessing DTS in SQL SERVER 2005 Jigna SQL Server DTS 1 September 12th, 2007 04:23 PM
Scheduling a task eelisMX Pro VB.NET 2002/2003 5 April 29th, 2007 11:57 PM
Running DTS package through Execute SQL / pkg Task sthekk SQL Server DTS 1 April 23rd, 2007 11:18 AM
scheduling a DTS package psugak SQL Server DTS 3 March 29th, 2007 01:26 PM
Scheduling DTS Package chiefg SQL Server DTS 11 April 30th, 2004 11:18 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.