December 23, 2011 at 1:23 pm
Idle curiosity: What is the purpose of the Build option in SSIS? I have a working package that is called as a daily job and it seems to be working fine. Do I need to do something else with this 'Build' option?
Sigerson
"No pressure, no diamonds." - Thomas Carlyle
December 23, 2011 at 1:51 pm
December 29, 2011 at 5:33 am
Hi,
Building a package is a standard Practice. When you deploye your package from Dev environment to Production environement, you should build your package, which will craete the .msi file in the default folder called \bin. Once yo get your .msi file you can go and deploy it in your Prod environment. The .msi is nothing but a manifest file.
Regards,
Chandrashekhar
December 29, 2011 at 5:43 am
CHANDRASHEKHAR SINGH (12/29/2011)
Hi,Building a package is a standard Practice. When you deploye your package from Dev environment to Production environement, you should build your package, which will craete the .msi file in the default folder called \bin. Once yo get your .msi file you can go and deploy it in your Prod environment. The .msi is nothing but a manifest file.
Regards,
Chandrashekhar
This answer is almost completely incorrect. If you don't know the answer, please do not just guess.
All that the build option does is ensure that the package in the \bin folder is up to date and, if enabled, creates a deployment manifest file.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply