title: How to parameterize database connection string in an SSIS package?
body: <p>I have a SSIS package built in Business Intellegience Development Studio which have both source and destination database specified. Now I want to use some variables to parameterize the database connections and run the package in a command line.</p>
  
  <p>I try to replace the database name and sql server instance with my variable @[User::SourceDb]. @[User::SourceHost], but it failed to connect to the database.</p>
  
  <p>Is that possible to paramterize the database and is there anything wrong with my variable useage? Thanks in advance!</p>