SSIS - Deployment utility problem - cannot copy configfile
In a SSIS-project you can set the property “Create deployment utility” to true. When building such a project you may get the error
“Could not copy file xxx.dtsconfig to the deployment utility output directory. File already exists.”
This was due to two packages using the same config file and Visual Studio wants to copy that file twice and errs on the second attempt.
WORKAROUND:
- Manually create a deployment-manifest. Name the file “ProjectName.SSISDeploymentManifest”. Save the file to the folder Drive:\FullPathToTheSSISProject\Install.
- Copy the needed files from the bin-folder to the install-folder
Example manifest-file:
<?xml version="1.0" ?> <DTSDeploymentManifest GeneratedBy="<Domain>\<UserName>" GeneratedFromProjectName="<ProjectName>" GeneratedDate="<Date><Time>" AllowConfigurationChanges="true"> <Package>Package1.dtsx</Package> <Package>Package.dtsx</Package> <ConfigurationFile>cp.xml</ConfigurationFile> <ConfigurationFile>cc.xml</ConfigurationFile> </DTSDeploymentManifest>
See also: http://support.microsoft.com/kb/910419
