Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Redeploying my package

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2008-10-08 : 11:55:46
I have my package deployed and scheduled to run each week. The business have asked me to change a requirement so i've done this. Can i just redeploy my package again and it will overwrite the orginal package ?.

Will this affect the schedule job ?

I will not change the name of the package so it will redeploy with same name hence the schedule job will still point to the package as the name won't change

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-08 : 14:48:12
you need to update that package in MSDB through which you job will kick updated package.
Go to Top of Page
   

- Advertisement -