dbTalk Databases Forums  

DTS Packages

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


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



Reply
 
Thread Tools Display Modes
  #1  
Old   
DTS job won''t run at all
 
Posts: n/a

Default DTS Packages - 01-12-2006 , 08:04 PM






Hi,

Is there a way to create a duplicate DTS packages, I would like to create an
exact same package, then modify it a bit, because some of my data wasn't
process. I am trying to get the data out of my HIST file and then re-run the
job again.

Many thanks,
Steve

Reply With Quote
  #2  
Old   
Ryan
 
Posts: n/a

Default Re: DTS Packages - 01-13-2006 , 03:07 AM






One way would be to Design the package in question and then "Save As"
something else. This will give you a copy of the original.

You could also modify your existing package, save it, and then roll back by
right clicking the package and choosing versions.

--
HTH. Ryan
"DTS job won''t run at all" <DTSjobwontrunatall (AT) discussions (DOT) microsoft.com>
wrote in message news:CD8B1080-41DD-4A98-842B-21A1B091CEB0 (AT) microsoft (DOT) com...
Quote:
Hi,

Is there a way to create a duplicate DTS packages, I would like to create
an
exact same package, then modify it a bit, because some of my data wasn't
process. I am trying to get the data out of my HIST file and then re-run
the
job again.

Many thanks,
Steve



Reply With Quote
  #3  
Old   
DTS job won''t run at all
 
Posts: n/a

Default Re: DTS Packages - 01-13-2006 , 12:31 PM



It works.

Thanks a lot!

Regards,
Steve

"Ryan" wrote:

Quote:
One way would be to Design the package in question and then "Save As"
something else. This will give you a copy of the original.

You could also modify your existing package, save it, and then roll back by
right clicking the package and choosing versions.

--
HTH. Ryan
"DTS job won''t run at all" <DTSjobwontrunatall (AT) discussions (DOT) microsoft.com
wrote

Hi,

Is there a way to create a duplicate DTS packages, I would like to create
an
exact same package, then modify it a bit, because some of my data wasn't
process. I am trying to get the data out of my HIST file and then re-run
the
job again.

Many thanks,
Steve




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.