SQL Server Performance

get variable values from table!!

Discussion in 'SQL Server 2005 Integration Services' started by patdev00, Jan 16, 2009.

  1. patdev00 New Member

    Hi all,

    how can i do this. I don't want to hard code the package variable values when i want to deploy package from dev to test or prod.

    Is there a way i can store in table and have it passed in when package execute. I know you can set the configuration file with xml or sql but need steps what to store in table or file.

    also how to execute config file before ssis package execution takes place!!

    Thanks
  2. satya Moderator

Share This Page