ASP.net page which executes a SQL-Server 08 SSIS Package and/or SP on remote SQL Instance(repost)
$30-40 USD
En curso
Publicado hace alrededor de 12 años
$30-40 USD
Pagado a la entrega
I need an asp.net page which has 2 prompts (Year and Period) and a button which, when clicked, passes the required prompt values to a remote SQL Server 2008 SSIS Package and executes it.
## Deliverables
* An ASP. net page is required
* There will be 2 numerical drop-down lists from which vaule selection will be required. The values for these will be fed from tables in a database. One selection will be for the "Year" and the second for "Period". Both values will be numbers and the Period will be displayed in calendar months ('Jan, Feb',etc...) but pass an equivalent number value to the SSIS Package.
* The users will make their selections then click a "Load Data" (or agreed upon verbiage) button which will execute an SSIS package, passing the Year and Period selections as parameters, and executing them on a remote DB server.
* The page will display a high-level status of activities and communicate an overall job summary status once the job is complete.
* An email will also be sent to a user, and/or a user or mail group communicating the job run status.
Security and architecture factors.
* The aspx page will be housed/located on an application server
* The DB and SSIS and SP is located on a separate physical SQL server instance
* The page must run using separate network service account which should be hard-coded for authentication
I'll included a mock-up snapshot of a sample page.