Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Profile >
Portfolio
Immaculate Data Solutions Private Limited

Execute Multiple Queries and Archive Excel Output

by Immaculate Data Solutions Private Limited, last login 168 days ago

Execute Multiple Queries and Archive Excel Output  Execute 4 queries dynamically based on given configuration Excel file and archive the results in Excel file. This execution is initiated from Remote machine

Solution :

1. Provide all the configuration parameters in Excel file in 
the Server (Shared Location)

2. Run the Job from Remote machine. This job constructs 
all the 4 queries dynamically and executed in the Server

3. Job executed in Server and Results are stored in table 
and finally imported to Excel (Shared location)

4. Batch file approach was used to enable the client to 
double click and achieve the result without any knowledge 
about SSIS and SQL MS SQL Server |  SSIS |  ETL |  HEALTHCARE DOMAIN
Description
Execute 4 queries dynamically based on given configuration Excel file and archive the results in Excel file. This execution is initiated from Remote machine

Solution :

1. Provide all the configuration parameters in Excel file in
the Server (Shared Location)

2. Run the Job from Remote machine. This job constructs
all the 4 queries dynamically and executed in the Server

3. Job executed in Server and Results are stored in table
and finally imported to Excel (Shared location)

4. Batch file approach was used to enable the client to
double click and achieve the result without any knowledge
about SSIS and SQL
Tags
MS SQL Server SSIS ETL HEALTHCARE DOMAIN
176985602337900
IN
Immaculate Data Solutions Private Limited

Immaculate Data Solutions Private Limited

Microsoft SQL Server Programming, Data Warehousing, SQL...
MADURAI, TAMILNADU
5.0
Not Yet Rated
35/hr
rate
About Immaculate Data Solutions Private Limited
Immaculate Data Solutions Private Limited has experts in skill areas
T-SQL, Performance Optimization, Database Administration, SSIS,
SSRS, SSAS, MDX and DMX. We are specialized providers in
Microsoft SQL Server.

We are providing smart services and cost effective solutions in Business Intelligence domain with the skilled work force of 18 for the last 2 years.
More Samples
Immaculate Data Solutions Private Limited | Elance

Immaculate Data Solutions Private Limited