Help with Connections

Hot Topic

where to place articles
Retrieving a piece of datalogged equipment by most recent time
Newbie! Help with AS errors against both MS SQL 2000/2005 database.
Experts required to validate these statements of fact
An unexplained error message for an Xquery
Report Builder "Report Execution Error"
help for starting SQL Express Manager 2005
Passing Command line arguments from Visual Studio
Problems with mimimum value for DateTime Package Variable since SP1
a general query and db question

SQL Server

SSIS will not start after SQL Server 2005 SP1 upgrade
Is Sql Mobile a generic database engine?
Error importing data from oracle database to an SQL database
AS2005 September CTP Memory Error
Create .SDF from .MDF File
Mirroring and orphaned users
Connection string for SqlCeConnection
Switching to WindowsAuthentication only
error: 17194
Error while using OUTPUT clause - The multi-part identifier could not be bound

Help with Connections

Hi everybody,

I need a little help...

I created several packages, that after their creation should not be changed again; that's why I created a Package Configuration File in which I set all the Connections I need, so that this is the only file I have to modify.

I set there also the path of the connections for my log file and for my error files (which are both text files), but if I change their paths in the configuration file this change doesn't affect the package, and the path of the log remains the same.

That's an image of one of those packages....

The fact is that I cannot change the ConnectionString of the connection called "log_pkg", but it always remains the same...

How can I resolve this problem

Thanks everyone

Answer this question

Help with Connections

  • Jeffrey D. Baker

    In general this should work. I just did a quick test where I had a package already which contained a Text Log Provider so I added an XML type configuration to the package, on just the connetion string. If I edit the config file and change the name of the file, rerun the package the, the new name is created.

    this was section of the config file I was editing, specifically the name in the string "ftp_Log2.txt"

    - <Configuration ConfiguredType="Property" Path="\Package.Connections[ftp_Log.txt].Properties[ConnectionString]" ValueType="String">
    <ConfiguredValue>C:\_work\SSISPackages\ProtectionLevelTest\ftp_Log2.txt</ConfiguredValue>
    </Configuration>
    You are doing something similar and it does not work
    When you execute in BI studio, do you see a message similar to the followingin the output window indicating the config file was read
    Information: 0x40016041 at ftptesting: The package is attempting to configure from the XML file "C:\SSISPackages\ftpconfig.dtsConfig".


  • Help with Connections
Answer this question