March 10, 2011 at 2:17 pm
Hi all,
I've got an issue with a project i'm trying to deploy onto SQL Server 2005. There are several packages already part of a solution (previously created), some packages I have modified and I have added one new package to the solution. Now I have created the manifest file by building the project.
However when I run the manifest file on the server, it deploys the existing packages in the solution into MSDB but does not deply the one package which I added. I have checked the manifest file and it includes the new package. I'm lost as to what it could be, can anyone help
All comments appreciated
March 11, 2011 at 8:24 am
When you build your project, the packages are copied to the bin\Deployment folder, where also the manifest file is created. Are the newly created packages also present in the bin\Deployment folder?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2011 at 5:29 am
Thats correct the new package is present in the deployment folder
Update: after being puzzled for some time this has finally been fixed and all packages deployed successfully. All I did was rename the package in BIDS (thinking maybe the length of the package was too long at 49 characters) and rebuild, it deployed successfully. HOWEVER, I renamed back and tried again and it deployed successfully again with the original name \:unsure:
all working now, thank you
March 13, 2011 at 4:04 am
flylife2k (3/12/2011)
Thats correct the new package is present in the deployment folderUpdate: after being puzzled for some time this has finally been fixed and all packages deployed successfully. All I did was rename the package in BIDS (thinking maybe the length of the package was too long at 49 characters) and rebuild, it deployed successfully. HOWEVER, I renamed back and tried again and it deployed successfully again with the original name \:unsure:
all working now, thank you
Hmmm, this sounds like a typical "Have you tried turning it off and on again"-Microsoft solution 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply