SSIS Configuration

Posted on 2011-04-19
Last Modified: 2013-11-10
Is the purpose of the configuration where you  click SSIS --> Package Configuration, to set the connection strings of the package such that when/if you have to move it you can go to the config package and make the adjustents?

Is there any other important aspect that one should know about configuration packages.
Question by:SeTech
    LVL 22

    Accepted Solution

    LVL 4

    Expert Comment

    by:Kalyanum Deepak Kumar
    Yes the sole purpose of SSIS configurations is to make the package function with respect to different environemnts without having to modify it frequently. This gives more information to you I have been working in SSIS for quite some time( 4 years)  using these configurations . ANy hlpe needed , post the issues.
    LVL 4

    Expert Comment

    by:Kalyanum Deepak Kumar
    Also, need to consider the security for the configuration files . The configuration files can be secured in a folder and the folder can be encrypted using the security features in windows. (sorry have been working for past 5 years for SQL Server 2000,2005,20082008R2 ).
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Configuration package is for pass parameter to package from outside the scope of package.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now