One of my users places a flat file on a shared drive every Monday for me to load using SSIS. The file always begins with SHIPP. I'd like to read the shared directory and only load files that start with SHIPP. There should only be one, mind you.Would using the Script Task be the best approach in SSIS doing this?
View 2 Replies
am developing an website where i am developing ticketing concept,but i am struck at one part,if once the employee view the ticket and solve it then the status should be changed,which i have done successfully but the solve query should not appear in the gridview again instead of that, it should go back to admin showing him dat issue is solvedso here my task is,how to make the query delete from the gridview after finishing the task and showing it to adming dat the ticket is solved
<
asp:GridView
ID="GridView4"
[code]...
I have a datagrid that the user can edit and click a checbox then input their initials to update a task. The update works except it does not record the userid field. Below is the gridview code and the vb/sql
[Code]....
I have just taken over a project from another programmer and want to add some functionality. The ASP.NET application allows users to sign up, fill out details about a company, and those details are submitted to companies house (very brief explanation!). These details are only submitted when an administrator logs in to the control panel and clicks a "Run Submissions" button. This then attempts to submit all pending formations to the gateway.
What I want to do is design an external desktop or console application, that "clicks" this button for me every set amount of minutes. The application will some how need to "log in".
I need a control which can have 10rows and 2 columns.i need the user to copy 10rows and 2 columns from excel i.e 20 cell values and paste in the above control on aspx page.Is there any control which will do like this.....
View 3 RepliesI am creating a feature which will allow users to import data of excel sheet to database.First, data will be imported from excel sheet and will be displayed in a tabular format.User performs a mapping porcess for database fields and click Submit button.Then a stored procedure inserts all the data of each row into more than 15 tables.
Above mentioned process might cause an issue if users import more than 1000 records (they are definitely going to do that. Thats why this entire functionality is intended for).Basically, what I would like to do is, Insert all the rows to a single table (Temp table), have a cloumn in a table which will be a flag and initially, will be set to "Pending".Create a page which will be executed when there are less users accessing the system (Specific time),
This page will see if there are records in a temp table with FLAG "Pending". If yes then it will fetch one record from the table and will insert data of first row into all the necessary tables. After first transaction it will wait for some time and will fetch the second record....This will last until the final row of temp table is reached.
While the economy has been in the shitter, I've written possibly the most coolest site EVER for unemployed developers looking to buzzword-ify their resumes. (Don't hate the player, hate the game.)
The only problem is, it needs a scheduled task to run once a day to do some data mining. I spent many, many hours a few months ago researching solutions, but nothing seemed sure-fire.
If I have shared hosting and cannot remote in (e.g. mstsc and create a Schedule Task), how can I create a task that will run once a day on the backend of an ASP.NET website?
After all the research I did, I don't think it's possible. Per my last analysis, someone has to visit the site at least once a day to instantiate an instance of HttpApplication.
Does anyone have any solution to making sure an operation runs automatically, no matter whether anyone visits the site, and without anything but FTP access to the website?
Like I said, I've done A LOT of looking into this in the past, and it didn't seem possible. IF YOU HAVE EXPERIENCE implementing a solution, contribute your advice! But not postulating or conjecturing needed--it's far more nuanced and difficult than you're surely imagining.
Im about to develop a site which will need 2 types of email function: the first will be simple enough, just a realtime email using system.net.mail when certain conditions are met in the underlying DB. the second is to send out an email at the end of each day covering everything that happened during the day. WOuld that have to be set up as a scheduled task?
View 3 Repliesmy task run only in windows explorer brower.. that not working in mozilla firebox.
View 6 RepliesI'm generating reports on the fly using the great SpreadSheetGear tool. At first things were great because the reports were simple and done in under 1 second. Now I'm at more complex reports and they are taking about 30 seconds up to 1 minute. This isn't a problem, we just throw up an activity image and let the user wait, fine by us.
The problem I've found is when two users come to the site.
User 1 comes to the site
User 1 runs a report that takes 30 seconds.
User 2 comes to the site
User 2 waits until user 1 report is done then the page loads.
The report running for User 1 hangs up the site until it's done. What is going on and how can I fix this?
I have added Ajax Control toolkit to my project. I added a ScriptManager to my page. None of the standard controls are showing the task menu with the "Add Extender..." option
View 6 RepliesThe ASP.NET runtime is meant for short work loads that can be run in parallel. I need to be able to schedule periodic events and background tasks that may or may not run for much longer periods.Given the above I have the following problems to deal with:
The AppDomain can shutdown due to changes (Web.config, bin, App_Code, etc.)
IIS recycles the AppPool on a regular basis (daily)
IIS itself might restart, or for that matter the server might crash
I'm not convinced that running this code inside ASP.NET is not the right thing to do, becuase it would allow for a simpler programming model. But doing so would require that an external service periodically makes requests to the app so that the application is keept running and that all background tasks are programmed with utter most care. They will have to be able to pause and resume thier work, in the event of an unexpected error.My current line of thinking goes something like this:
If all jobs are registered in the database, it should be possible to use the database as a bookkeeping mechanism. In the case of an error, the database would contain all state necessary to resume the operation at the next opportunity given.I'd really appriecate some feedback/advice, on this matter. I've been considering running a windows service and using some RPC solution as well, but it doesn't have the same appeal to me. And I'd instead have a lot of deployment issues and sycnhronizing tasks and code cross several applications. Due to my business needs this is less than optimial.
I want to create task list in asp.net to assing a task particular login of person by using asp.net and sqlserver database .
View 1 RepliesHow can I add a Task in Windows Scheduled Tasks using Asp.Net.
How to execute asp.NET code in scheduled task of windows?
View 5 RepliesI want to know how to show the progress bar in WEB while updating the status of progress bar percentage and Status of the application I am trying to built a web application in which I update the scripts from SQLServer to another SQLServer using TransactionScope using Stored Procedures. Here in my app I want to show the progress bar. and its percentage completion of the SP or task and simultaneously updates of the scripts execution.
i.e., Table 1 created, Table2 creation in progress like that or updates etc. Status of application.
I have developed a web application which downloads files from FTP server. I want to run this application every day at 09:00 and automatically closed when the job is done.
I tried javascripts "window.close, self.close etc" but couldn't workd.
It is worth mentioning that the website is hosted on Windows Server 2003.
I need to implement task based file management engine. See picture:
So, I need to create Transformation Engine and Transformation rules parser. Does something like this already exist?
UPDATE
Input: Some files and metadata.
Output: Some of input files (maybe all, depends on rules) with another folder structure and file names. Xml files can be transformed with xslt to different text files.
I have to implement Scheduler like outlook in my .NET application.I have already started working on it but I can't implement Recurrence Pattern. how could i achieve this functionality. how to save task with Recurrence in database? I found this RadScheduler for ASP.NET AJAX but unfortunately this controller is commercial
View 1 RepliesI am working on roles. Allocated some tasks to Annonumous User and LoggedIn User. What happen, once I login it shows me the correct task for LoggedIn user. But if I restart the application then by default it shows me LoggedIn users tasks. I am testing chrome and I.E.
View 1 Repliesim looking for help dealing with some task. im wondering if there is any code that can automatic delete all files and folders in server folder. I have folder call "uploads" and i want to: first option - delete all the folders and files that in that folder in some day and hour every week (lets say every sunday at 3 am), and if its not possible, option 2 - to trigger that process with button (delete all folders and files in "uploads" folder after click that button.
View 5 RepliesI have a sharepoint event handler attached to task list. This work fine but I have 3 task list in my site and I want that handler trigger only to one task list.I already used the listtemplateId 107.
View 8 RepliesThe host I use for our site lets us schedule a task, we can pointo the site and a file on the site. I'm not clear on how to make the file I point to actualy do something like run a stored procedure or send and smtp email or run some code in my app.
View 3 RepliesI am trying to use schedule task on the server from the web application hosted in IIS. I have written the code to create Task and passing the valid username/password under which this task needs to run on server. But I get an error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access. The same code works well with console and windows service and able to create task. I understand that this is security issue. My sample app is attached at: [URL]
Need a way to write in c# something that we can query access database and send out individual emails using 3 seperate templates based on the users selection. basically users have been signing up to receive an email later in the year.. there are 3 possible email templates that are designed and will be sent based on what the user selected. So when the time comes, we need to take and query the access database and send an email to the user with the template they picked.
I see alot of software packages, but cost more than what we can spend(no budget), so we need something simple and free that can be scheduled to send on certain day and time. Or if there are any tutorials on creating something to do this, doesnt need to be fancy
