Programming SSIS Shared Connection in SQL Server 2012 RRS feed

  • Frage

  • Hi,

    I'm currently programatically creating SSIS packages on SQL Server 2012.

    In general this works well, but now I'm having an issue with the newly Shared Connections in SSIS 2012. These connection managers are stored on a project level and are referenced by the packages.

    In older SQL Versions the code for generating a new Connection Manager was somehting like:

    ConnectionManager staging = package.Connections.Add("OLEDB"); staging.ConnectionString = "DataSource=..." staging.Name = "OLEDB Connection";

    Now I'm having no idea how to access the Shared Connections in the above example. I found that the property "PackagePath" is different in the Shared Connecton Managers - compared to the "old" Connection Managers stored in the package -  but this property can't be overwritten in the code (neither in the designer)

    I also can't find any information on that topic here:
    Can I somehow overwrite the Package Path Property or do I have to add the Connection Manager in another way?

    Does some have an idea how this can be solved?

    Thanks for your answers!

    Freitag, 11. Mai 2012 12:43