dbTalk Databases Forums  

Scheduling DTS packages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Scheduling DTS packages in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
datacomms13003
 
Posts: n/a

Default Scheduling DTS packages - 04-21-2005 , 09:13 AM






Hi,

I have DTS package that imports data into an SQL table and works fine when I
execute it manually. When I schedule the package to run automatically every
hour, it says that the job has completed successfully and it re-schedules
itself to run the next hour, but it doesn't import any data into the table.

Please help.

Thanks !

Reply With Quote
  #2  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Scheduling DTS packages - 04-21-2005 , 01:07 PM






See the reply to the post just before this one on the same subject.

--
Andrew J. Kelly SQL MVP


"datacomms13003" <datacomms13003 (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,

I have DTS package that imports data into an SQL table and works fine when
I
execute it manually. When I schedule the package to run automatically
every
hour, it says that the job has completed successfully and it re-schedules
itself to run the next hour, but it doesn't import any data into the
table.

Please help.

Thanks !



Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.