Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 25th, 2005, 05:37 PM
Friend of Wrox
 
Join Date: Jun 2004
Location: Alhambra, ca, USA.
Posts: 245
Thanks: 0
Thanked 0 Times in 0 Posts
Default DTS Schedule Package Ques

Hello
I am having a problem setting up the scheduling of a DTS package. The package is correct because when I execute it by hand it runs fines. However I have tried to schedule this two ways and it is not working.

First of all when I created the DTS package by export data in SQL Server 2000, towards the last screen there is an option to run immediately or schedule it. I clicked the '...' button to schedule it and set the date and time (daily at noon for example). It DTS finished by saying that there were no errors. But the DTS doesn't execute. I looked at the empty table it is suppose to populate and I set it so after it successfully executes it sends me the email- and of course I get no email.

Then I tried another way, by saving it as SQL Server rather than Meta Data Services or Structured storage file. Then I went to Data Transformation Services --> Local Package --> Right click --> select
Schedule Package to set the date and time the click ok. It doesn't run.
What I noticed is that after I Schedule Package, it doesn't save those setting. When I go to Schedule Package again, it shows the defaults. Is it suppose to do that?

Also SQL Server Agent is running.

Help me. Thank you.


  #2 (permalink)  
Old December 8th, 2005, 02:34 PM
Authorized User
 
Join Date: Dec 2005
Location: Manhattan, Kansas, USA.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hemanth_p2p
Default

Just a thought! Did u by chance modify the package after scheduling. If yes, I think DTS assigns a new GUID each time the package is changed. Just try pointing to the package again and scheduling it.
Hope it helps.
----

Distributed computing ->Causality-> EventDriven ->We have the last laugh.!!
  #3 (permalink)  
Old December 22nd, 2005, 01:11 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

The DTS Designer in Enterprise Manager creates a new version GUID, but the Package GUID remains the same. When the Wizards schedule a DTS package for you they use the Package GUID not the version GUID. So while hemanth_p2p has a good thought process the GUID is not the problem.

David_the_DBA
www.mutuallybeneficial.com
  #4 (permalink)  
Old December 22nd, 2005, 02:08 PM
Authorized User
 
Join Date: Nov 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Make sure 'Enabled' option is checked in Schedule tab.

  #5 (permalink)  
Old December 22nd, 2005, 08:28 PM
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

Bekim,

To solve your problem we need to enable DTS Logging. Open the DTS package, right click on some whitespace in the Package, select Properties. Then click on the Logging Tab (beware of overanxious environmentalists ;) then check the box next to Log package execution to SQL Server. If this is the default instance then accepting the default of local with windows authentication will do. If this is a named instance you need to space the named instance in the Server text box.

Then click OK. Save your package. Exit the DTS Designer. Go to Jobs, run the job by right clicking on the job and selecting Start Job. When the job is done, return to the DTS area of Enterprise Manager, Right click on the Package and select Package Logs. In here you will be able to see what steps ran and what steps did not.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
  #6 (permalink)  
Old January 12th, 2006, 03:51 PM
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

Bekim,

Any result?

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
  #7 (permalink)  
Old March 9th, 2006, 03:59 PM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

scheduling the dts creates an sql agent job , but the job doesn't show up when you go to the jobs , you need to manually refresh jobs view
  #8 (permalink)  
Old April 12th, 2006, 04:40 AM
Registered User
 
Join Date: Apr 2006
Location: Reading, , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, it does solve my problem! Many thanks.:)

To be is to do
To do is to be
To be do be do
  #9 (permalink)  
Old May 8th, 2006, 09:57 AM
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have been searhing all over the web for help with a similar problem. Thank you very much for posting this information!

I have taken over as DBA for a position that has been vacant for 1 year and the last worker left no documentation.... it has been a nightmare figuring why things have been failing for months! Thanks again.

  #10 (permalink)  
Old May 11th, 2006, 10:52 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

To do some more advanced logging in DTS that will make your logs more usable and readable look at:
http://www.mutuallybeneficial.com/in...s_portable.htm
http://www.mutuallybeneficial.com/co...ing_Script.txt

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with DTS PACKAGE mxwebb SQL Server DTS 1 November 28th, 2007 05:16 PM
don't run my package when i schedule package Isra2005 SQL Server DTS 1 May 17th, 2005 01:34 AM
Can only members of sysadmin schedule DTS jobs? Crowandazi SQL Server DTS 1 March 10th, 2005 02:53 AM
Unable to Schedule or See Existing DTS Jobs Crowandazi SQL Server DTS 1 March 4th, 2005 03:43 PM
DTS Schedule import data fails ppenn SQL Server 2000 4 November 5th, 2003 06:48 AM



All times are GMT -4. The time now is 09:22 PM.


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