Post reply

Package Configurations....

  • June 15, 2011 at 3:54 am

    #239920

    Quite new to SSIS and obviously Package Configurations.

    I have inherited a system where an external application alters the XML package configuration to define an XML Source File Path.

    This application no longer works and I want to recreate something within SSIS.

    I hoped that by moving the Config into a SQL Server table I can update the Source Path using Script or SQL and import the data.

    While I can just about understand the XML Config File I have no idea how to re-create it in the table (ConfigurationFilter etc)

    HELP 🙁

  • June 15, 2011 at 4:27 am

    #1338855

    If you already have a package configuration in your package, you should be able to edit it. Click on the Edit button and change the configuration type to SQL Server. If there are no other package configurations (either in this package or any other) that will use the table you choose, you don't need to worry about the configuration filter - just type anything in. Click on Next and you should see the same properties selected that were in your XML file. Click on Next again and Finish and the configuration will be written to your table.

    John

  • June 15, 2011 at 4:32 am

    #1338858

    You can evaluate Annotated XSD Schemas, I never used but looks like it might help you:

    http://msdn.microsoft.com/en-us/library/ms171870.aspx

    Regards,

    Iulian

  • June 15, 2011 at 6:53 am

    #1338931

    John Mitchell-245523 (6/15/2011)

    If you already have a package configuration in your package, you should be able to edit it. Click on the Edit button and change the configuration type to SQL Server. If there are no other package configurations (either in this package or any other) that will use the table you choose, you don't need to worry about the configuration filter - just type anything in. Click on Next and you should see the same properties selected that were in your XML file. Click on Next again and Finish and the configuration will be written to your table.

    John

    🙂

    Thanks

    Had to fiddle around a bit adding in a new connection manager and changing the connection string to include the password but got it working eventually 😎

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply