 | |
copying a job
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
copying a job -
02-03-2004
, 01:44 PM
#2
| |||
| |||
|
|
Hello, I need to make a copy of a dts job to modify. I don't have the package existing, where i could go and create the job. I have the job though but there is no option to do save as or copy an save. how do i make a copy. Help!! |
#3
| |||
| |||
|
|
-----Original Message----- Make a copy of a job? Script it out and change the bits you need to change Right Click the job | All tasks | Generate SQL Script -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "desperate" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:9b2601c3ea8e$1bbef1a0$a601280a (AT) phx (DOT) gbl... Hello, I need to make a copy of a dts job to modify. I don't have the package existing, where i could go and create the job. I have the job though but there is no option to do save as or copy an save. how do i make a copy. Help!! . |
#4
| |||
| |||
|
|
Hi Allan, Thanks for the reply on make a copy of a job. I could generate sql script from an existing job that i want to copy. but how do i save the sql script(change it) to a job. Please help. Thank you so much. -----Original Message----- Make a copy of a job? Script it out and change the bits you need to change Right Click the job | All tasks | Generate SQL Script -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "desperate" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:9b2601c3ea8e$1bbef1a0$a601280a (AT) phx (DOT) gbl... Hello, I need to make a copy of a dts job to modify. I don't have the package existing, where i could go and create the job. I have the job though but there is no option to do save as or copy an save. how do i make a copy. Help!! . |
#5
| |||
| |||
|
|
-----Original Message----- Save it to a file and use osql.(or play it back in QA.) -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "desperate" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:906301c3ea95$2ad7ac70$a101280a (AT) phx (DOT) gbl... Hi Allan, Thanks for the reply on make a copy of a job. I could generate sql script from an existing job that i want to copy. but how do i save the sql script(change it) to a job. Please help. Thank you so much. -----Original Message----- Make a copy of a job? Script it out and change the bits you need to change Right Click the job | All tasks | Generate SQL Script -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "desperate" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:9b2601c3ea8e$1bbef1a0$a601280a (AT) phx (DOT) gbl... Hello, I need to make a copy of a dts job to modify. I don't have the package existing, where i could go and create the job. I have the job though but there is no option to do save as or copy an save. how do i make a copy. Help!! . . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.