dbTalk Databases Forums  

DTS Tasks

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


Discuss DTS Tasks in the microsoft.public.sqlserver.dts forum.



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

Default DTS Tasks - 05-02-2005 , 12:19 PM






Hi All,

I would like to know how to get the date that a package was LAST executed?
also, how do I move a group of packages to another server?

Thanks...M



Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: DTS Tasks - 05-02-2005 , 09:22 PM






Date last executed depends - are you using package logs, are
they executed through jobs, etc.
In terms of moving a group of packages, you'd want to refer
to the following article for different options:
Transferring DTS Packages
http://www.sqldts.com/default.aspx?204

-Sue

On Mon, 2 May 2005 13:19:36 -0400, "Michelle"
<smiley2211 (AT) yahoo (DOT) com> wrote:

Quote:
Hi All,

I would like to know how to get the date that a package was LAST executed?
also, how do I move a group of packages to another server?

Thanks...M



Reply With Quote
  #3  
Old   
Michelle
 
Posts: n/a

Default Re: DTS Tasks - 05-03-2005 , 01:07 PM



Thanks...yes, I was able to find what I needed in msdb..sysdtspackagelog and
sysdtspackages.

Thanks...M

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

Quote:
Date last executed depends - are you using package logs, are
they executed through jobs, etc.
In terms of moving a group of packages, you'd want to refer
to the following article for different options:
Transferring DTS Packages
http://www.sqldts.com/default.aspx?204

-Sue

On Mon, 2 May 2005 13:19:36 -0400, "Michelle"
smiley2211 (AT) yahoo (DOT) com> wrote:

Hi All,

I would like to know how to get the date that a package was LAST executed?
also, how do I move a group of packages to another server?

Thanks...M





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.