View Complete Post
I am in trying to design ETL process using SSIS 2008. The source (DB2 and Siebel) has tables Tbl_s1, Tbl_s2, Tbl_s3 …. Tbl_sN and
the destination (SQL Server 2008) has Tbl_d1, Tbl_d2, Tbl_d3 …. Tbl_dN tables, where Tbl_s1 has the same structure as Tbl_d1 i.e.
Tbl_s1 -> Tbl_d1 , similarly
Tbl_s2 -> Tbl_d2 ….. Tbl_sN -> Tbl_dN.
The data in destination tables is to be truncated and should be reloaded with source data for all
tables. Every time the package is executed and the packages requires to process different regional data based on the parameter value that is being passed during runtime.
What things need to take care when designing a new WCF, which would be consuming by external services.
In terms of input parameter and output type, there would be mixed types (string, enum and others), output parameter would be Typed.
I would looking for your expert advice. also in terms of non functional requirement and deployment.