0

Hi guys,


Need you inputs on my query.
I have an excel file which we have to upload weekly.
They want me to make an application using SSRS (MS SQL) . To read the excel file from a certain folder
And then make some data entry to inputs like date and time and types of transaction using drop down. Then the user will trigger button clicking to save the records from excel file to table.

Is this possible guys to do in SSRS?

Jov

3
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by jovillanuev
0

No. cause i use SSIS in BIDS. When i open the application there is a form and perform data entry. Okay, get back to you guys, i will confirm with the user.

0

Hey it is possible !!
1.Use SSIS to load data into data base
2.use SSRS to show data into web browser
3.Now here is the trick your SSIS package shold always point to same excel file show that whenever you edit it and SSIS pakage get run you will always have recent data

0

Thank you for this info. How could i connect the SSIS to SSRS? meaning i have to copy every time i have the data to upload or save in the excel file that the SSIS run.
I would like to create a portal?

Rgards,

Jov

Edited by jovillanuev: n/a

0

What should be my Front End? Can I used the SSRS as front end for my Web Portal?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.