title: Moving data from around 600 tables from one database to other
body: <p>I got a database with 650 tables and need to move the data from these tables to tables in another database. Table names are same in the two databases. We need to add a small transformation(Need to prefix text in one of the columns) in between. I am using SSIS to transfer the data. I think it is very hard to have 650 dataflows. Is there any easy way to have the data transferred along with the transformation.</p>
  
  <p>Thanks in advance</p>