locked
Denali CTP3 SSIS Configuration table use resulting in 0x80131904 connection error

    Question

  • Problem:

    When I try to use a configuration for Source A, I encounter an error message:

    Error: System.Runtime.InteropServices.COMException (0x80131904): Exception from HRESULT: 0x80131904

       at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)

       at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)

       at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction

    Background:

    Package 1) Get metadata from live Source A, create import/rawdata tables in Dev DW A

    Package 2) Get metadata from live Source A, create import/rawdata tables in Live DW A

    Configuration- Use sql server table

    Connection methods- .Net and OLEDB with SQL Server auth for Source A, ODBC for mysql DW, .Net with windows auth for sql server config db

     

    Data in config table:

    ConfigurationFilter  ConfiguredValue PackagePath ConfiguredValueType
    SourceA Data Source=DatabaseServer;User ID=company_SourceA_reporter;Initial Catalog=company_SourceA;Persist Security Info=True;Application Name=SSIS-Package-{634F9A52-0999-465C-8A76-D6307093A537}DatabaseServer;.company_SourceA.company_SourceA_reporter1; \Package.Connections[SourceA NET].Properties[ConnectionString] String
    SourceA   \Package.Connections[SourceA NET].Properties[Description] String
    SourceA company_SourceA \Package.Connections[SourceA NET].Properties[InitialCatalog] String
    SourceA SourceA NET \Package.Connections[SourceA NET].Properties[Name] String
    SourceA password \Package.Connections[SourceA NET].Properties[Password] String
    SourceA 1 \Package.Connections[SourceA NET].Properties[ProtectionLevel] Object
    SourceA FALSE \Package.Connections[SourceA NET].Properties[RetainSameConnection] Boolean
    SourceA DatabaseServer; \Package.Connections[SourceA NET].Properties[ServerName] String
    SourceA company_SourceA_reporter \Package.Connections[SourceA NET].Properties[UserName] String

     Attempts at resolution so far:

    1) Create new ssis config table for Source A connection details - same error message

    2) Overwrite config details with those that work on the connection - once I update the password and run I get the same error message

     

     


    Tuesday, January 10, 2012 1:52 PM

All replies

  • Hello Stephanie,

    What this "live Source A" is, can we know?


    Arthur My Blog
    Wednesday, January 25, 2012 4:46 PM
  • @Stephanie: I want to retrieve SSIS package(Deployed under catalog in Denali) properties(Package file (.dtsx) Path in File system) either via T-SQL commands or via SMO assembly in c# code, can you provide any suggestion on this?

    Thanks,

    Aman

    Monday, February 13, 2012 5:58 AM