We are getting data from an external website via BizTalk 2009. Several SQL Server tables are being updated with this data through a SQL adapter and SOAP. So the Visual Studio 2008 project that already updates tables has schemas and mappings. I need to add 3 columns to each SQL Server table so these columns are also updated with data from that website (those columns are already in the website and the SQL Server tables just need to be updated with that data).
I can add column to the actual SQL tables (using ALTER TABLE), but how would I actually retrieve data from that website through the Visual Server project so these tables are updated? Do I add columns to the schema? In the schemas I see a "Before" node, an "After" node and an "Update" node, each with column names below.
