Re: Shared Configuration file build problem

Allan,

Thank you for your help so far.
I am now using master package variable to get me working, but I would much
prefer to use configuration files.

Can you advise me on how I can progress this issue. Does it need to be
reported as a bug?

Thanks again,

Mike
"Allan Mitchell" wrote:

Hello programmer_mike,

I can repro quite happily i just cannot get the fix I used last week to work.
My experiment says you can delete the config files and still builld the
solution.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I now have a simple test system set up for this.

I have 2 packages (just issuing sql select staments).

Project builds ok

I select enable package configuration for Package1.
I go through the wizard, selecting xml, and selecting the connection
string
properties to be saved.
I've tried linking to a fully qualified path, just giving the file
name, and putting a "\" in front of the file name as you indicated.

All is well until I cinfigure the second package.
I specify the file, it prompts me to "Use Existing File" (which I
agree to)
and I follow the wizard through a second time.
Then I get the build error.
I'm using Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00
Let me know if you need any more info, and thanks for taking a look at
this.

Mike

"Allan Mitchell" wrote:

Hello programmer_mike,

I saw this error this week in class. I deleted the file form the
location dpeocified in the configurations. That said I am trying to
repro your issue. I have created a config with a path to the XML file
of

\NameOfFile.dtsConfig

This works fine for me.

Can you tell me more about the setup and your error?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
I have a project with 12+ packages, all using a shared config file.
I have placed the config file in the same directory as the packages,
and all
of the packages are using relative file paths to find it.
When I set my Project Settings to CreateDeploymentUtility=true, I
get
a
build error saying that the config file cannot be copied because it
already
exists.
I have tried with the AllowConfigurationChanges property set to true
and
false, but this doesn't help.
Thanks in advance for any help on this,



.

Relevant Pages

  • Re: [opensuse] How do I keep monitor from going to sleep
    ... It is controlled by the package maker via the spec file. ... I believe the package maker should know if the old config file would no ... trust the packager to stay true to the package programmers and install, ... That is one of the reason I ...
    (SuSE)
  • Re: Shared Configuration file build problem
    ... "Allan Mitchell" wrote: ... I select enable package configuration for Package1. ... I have placed the config file in the same directory as the ... I have tried with the AllowConfigurationChanges property set to ...
    (microsoft.public.sqlserver.dts)
  • Re: Shared Configuration file build problem
    ... "Allan Mitchell" wrote: ... I select enable package configuration for Package1. ... I have placed the config file in the same directory as the ... I have tried with the AllowConfigurationChanges property set to ...
    (microsoft.public.sqlserver.dts)
  • Re: Conventions for NFS sharing of binaries
    ... I installed a package in /usr/local which would ... if a shared package puts a config file in a shared ... >> If I want to install a different version of a software from source ... the RPM version or the ...
    (comp.os.linux.misc)
  • Re: config files in packages (Re: (proposal) new flag forpkg_delete)
    ... > I have been playing with your package for a little while now. ... You're point about the base install didn't ... I need to work out exactly how the ports/package system can find the file, ... no other config file existed, or the last user-created config file if one ...
    (freebsd-arch)