Dear all,
I want to integrate data from different server for generating report.
I have to integrate data from two SQL Server(2000)database located in different server and one CRM database in different server.
My Problem is that, i have a SQL SERVER Database named as suppose A on one server. In database A I have a table as SalesDeleveryOrder, an other SQL Server Database as B having table Name YearlySalesTarget and QuarterlySalesTarget and A CRM Database on diffrent server having table name SalesDelevryDispatch.
I want to integrate salesDelivery data from database A and SalesDelevryDispatch from CRM into database B to generate report.
I am generating repot using dynamic excel in ASP.NET 1.1
Pls guide me how it is possible.
Regards,
Atul Sharma