Hi All,
My Application architechture has one centralized data base server with multiple client db (Ms SQL 2005) and different clients has their own database servers at theri own location.
At the end of day I have to ship the logs from each of the client's database and sync to the centralized database.
Can any one help me telling step by step method to build SSIS package for log shipping.
Any response is appreciated...
Thanks