October 12, 2009 at 5:13 am
Hi,
i was trying to add configuration file into my existing SSIS package but
its giving following error
acc to this error , i have added Dtsconfig file into more then one places
can anybody tell me , what are the areas i need to look so that i can remover extra dtsconfig file
------------------------------------------------------------------------------------------
Error3System.ApplicationException: Could not copy file "C:\cventapp\Internal\DataDump\Dev\DumpMain\SetUp\event.dtsConfig" to the deployment utility output directory "C:\cventapp\Internal\DataDump\Dev\DumpMain\SetUp\bin\Deployment". ---> System.IO.IOException: The file 'C:\cventapp\Internal\DataDump\Dev\DumpMain\SetUp\bin\Deployment\event.dtsConfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) --- End of inner exception stack trace --- at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow)00
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2009 at 7:09 am
You can ignore that error, but you'll have to create the deployment manifest file manually. This happens when more than one package in your project uses the same config file.
There is a hotfix that will prevent the error. http://support.microsoft.com/kb/910419
The article contains a link to the hotfix and a workaround telling you how to create the deployment manifest.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply