January 30, 2009 at 2:02 pm
Hello ALL.,
i developed,build and deployed 5 ssis packages. and also i scheduled jobs in sql server few jobs nightly few jobs hourly.
now i have to change a little bit modification to SSIS (such as changing some code in script task)
then after changes what steps do i need to take care,
do i need to re build & redeploy again all packages
and how about jobs in sql server 2005, do i need to remove & recreate all jobs again
Please help me in regards with above issue
Best Regards
asita
January 30, 2009 at 2:51 pm
From BOL
http://msdn.microsoft.com/en-us/library/ms141124(SQL.90).aspx
After you finish updating the packages, you rebuild the project, copy the deployment folder to the target computer, and then rerun the Package Installation Wizard.
If you update only a few packages in the project, you may not want to redeploy the entire project. To deploy only a few packages, you can create a new Integration Services project, add the updated packages to the new project, and then build and deploy the project. Package configurations are automatically copied with the package when you add the package to a different project.
February 2, 2009 at 3:57 am
Have you deployed the packages on sysdtspackages90 table of msdb database?
If yes then after changing the packages redeploy them.
The SQL Agent Jobs do not need to be modified.
Thanks
Pankaj
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply