Post reply

Package Configuration. What is better - XML,SQL Server?

  • September 18, 2008 at 7:14 am

    #123578

    Package Configuration

    I am trying to decide where to store

    my text files paths, database names,etc.

    Editing XML configuration file is not fun. Hard to read.

    I didn't like it.

    Then I tried "SQL Server" Configuration Type

    and it seems to be a good place but if I modify any

    Task which properties are used in Package Configuration

    it will probably break the SSIS?

    What do you guys use?

    XML,SQL Server,Environment variable?

    What would you recommend?

  • September 18, 2008 at 8:14 am

    #873638

    Personal preference is for SQL server, but I know a lot of people rave about XML configurations.

    Mine came down to that I had to save some passwords and I didnt want to expose these to the operational guys performing package deployments. If you choose XML, your passwords become exposed.

    ~PD

Viewing 2 posts - 1 through 1 (of 1 total)

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