• Generate Config files for Dev, Test and Prod environment. [ Values to SSIS package variables like File Paths,Server Name , DB name connections,etc..]

    SSIS package is same across all environments. which will take values from the config files for corresponding environment

    Prepare a Deployment Guidelines for SSIS package. Below one gives info.

    [http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/]

    Regards,

    SP