DataSource Controls :: DTS Runs Manually But Not Scheduled?
Nov 15, 2010
I have a DTS package that runs fine manually but gives the follow error when I create a job for it:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0
The package logs into a Teradata source and fill a local SQL table. That's it!
View 4 Replies
Similar Messages:
Mar 18, 2010
I would like to create a trigger which runs on record set and I would like to do IF UPDATE(column) on individual records.
View 3 Replies
Nov 11, 2010
i would like to sort a listview. i don't have a datasourceID. i bind the datasource manually. i think of using jquery(tablesorter) but i don't know how to use it.
View 1 Replies
Jul 18, 2013
I am a .net developer. I am developing an application in which i need to send scheduled sms to users mobile number which is stored in database(SQl Server 2008) automatically.
I have already buy sms gateway. How can I do this. Is there any way to call a asp.net page automatically periodically.?
View 1 Replies
Aug 30, 2010
I want to calcultae how many employees are scheduled less 24 hrs for each week,b/w 24 and 48 and greater than 48
In excel file i have weekly wise total hours scheduled for each employee and total no of days scheduled in week(example 6 days and 1 off)which i will upload it to database,based on this i want to display reports in bound controls Result should be like this
Scheduled Hrs 8/1/2010
8/8/2010 8/15/2010 8/22/2010
Less than 24 hrs 5% 5% 5% 5%
Between 24 and 48 hrs 5% 6* 3% 4%
greater tan 48 hrs 90% 89% 92% 91%
can u tell me Which control to use and words in bold are headers and dates should be dyanamic this month it is like shown above, next week it will change.so header should be dynamic.
View 3 Replies
Sep 12, 2010
I have some dropdown list boxes that I need to fill with data from a database but I also need the first option to be "Show All"... So I need to combine using a datasource and manually adding an item to the top of the list. I have tried two different ways with no luck:
1. with the appendDataboundItems = true, on aspx page, and below code in codebehind:
//lstClass.Items.Clear();
View 9 Replies
Jul 1, 2010
i need to make something like a "Live Help" image, that depending on a day or time it will show imageA or imageB. the site is in .net however i could use javascript it it's better that way
View 3 Replies
Aug 30, 2010
I have weekly wise scheduled hours of each employee and no of days scheduled for each employee,now i need to calculate no of employees scheduled less than 24 hours,no of emp's scheduled b/w 24 and 48 hrs and emp's scheduled more than 48 hrs in percentage for fisrt week,second week,3rd week and 4th week.
Like this
SCheduled Hrs 8/1/2010 8/8/2010 8/15/2010 8/22/2010
Less tha 24 hrs 5% 5% 5% 5%
b/w 24 and 48 hrs 4% 5% 5% 5%
>48 91% 90% 90% 90%
View 5 Replies
May 19, 2010
I have some code written in a method of an aspx page which I would also like to run as scheduled job on my in Windows Server 2008. How do I accomplish this?
View 5 Replies
Mar 1, 2011
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 Replies
Oct 22, 2010
I have a Quartz.NET application where I need the administrators to be able to modify the job details - mostly information in each jobs datamap, but also things like the triggers - here is my code I'm using
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
JobDetail jobDetail = sched.GetJobDetail(hdnID.Value, hdnGroupID.Value);
jobDetail.JobDataMap["idname"] = txtName.Text;
jobDetail.JobDataMap["initialPath"] = TextBox1.Text;
jobDetail.JobDataMap["targetPath"] = TextBox2.Text;
[code]...
View 1 Replies
Mar 14, 2011
How can I add a Task in Windows Scheduled Tasks using Asp.Net.
View 3 Replies
May 28, 2010
How to execute asp.NET code in scheduled task of windows?
View 5 Replies
Nov 21, 2010
How to run scheduled jobs from ASP.NET without requiring a Windows Service to be installed on the server?
View 1 Replies
Dec 1, 2011
Any way to scheduled tasks on a shared hosting? So like I can send email every two hours.
View 4 Replies
Mar 9, 2011
I have a windows shared hosting and i need to run some scheduled c# executable every day for create sitemap, send newsletter,etc...The provider tell me that i can't run executable for security reason.Whay can i do?The provider suggest me to buy a VPS, but do not think it makes sense to spend more money just to run some scheduled task.
View 3 Replies
Dec 27, 2010
As indicated in the Subject, I have a web application (say APP) that should feature an e-Mail Notification Service (ENS). Activation of the Service is controlled by a Button in a dedicated page where some parameters are also included to set running Period (FromTime - ToTime), Interval, Recipients, etc.
When said button is clicked, it should maintain those parameters into database then launch ENS. Since ENS is expected to run for good according to set parameters, it logically should run as an external application/service, independent from APP.
When ENS starts, it needs to consult database to fetch parameters, then schedules its Timer to periodically check database for some transactions that when found, should trigger ENS to dispatch e-Mails to concerned Recipient(s).
CHALLENGES:
1. Launch ENS as an external application on button click from APP.Achieved by using System.Diagnostics.Process class. However, I encountered a problem in verifying if the process is already running before starting it. The root of the problem lies in
ProcessName property. Since ALL web applications must be launched via IE, hence, have
iexplore as their ProcessName, which is also applicable to all processes started through IE, it is very likely to have multiple processes utilising IE. How to check which is which? I couldn't figure out that.
Eventually, I ended up with a workaround: when the Process is started from APP, capture its ID and save it to database, then use this ID with GetProcessById() method for later verification. When the Process is terminated, reset stored ID in database.
2. What sort of application should ENS be: Windows Application or Web Application?
In either way however, ENS will always run invisible in the background being a Process. If this is the case, how about creating it as a Windows Service instead?
I did a lot of reading but still confused. However, the choice is limited now to either Web Application or Windows Service. Which one is more convenient to the task in hand?
3. What Timer to use?
I tried System.Timers.Timer in a test web application but it didn't fire! Then I used ASP AJAX Timer and it worked pretty well (I still need though to try running it from APP to judge its functionality). I came across some recommendations to use System.Threading.Timer but haven't tested that yet. Would it worth the trial?
4. ENS as a Windows Service.
If I create ENS as a Windows Service, would I be able to communicate with database? How would this influence the Timer to use?
View 4 Replies
Aug 24, 2010
i bought a hosting plan that allows me to send about 500email/per hour but my client wish to send about 2000 or 3000 email at a time. is there a way to split them and 500 email per a time automaticly without the need of reloging again every hour. my hosting plan doesn't allow me to create a sql jop or send mails via Sql Server.
View 6 Replies
Mar 30, 2013
i wnat to sechdule message on asp.net. Like if i create a messge reminder to registerd members so they recive messge on paricular date time.
View 1 Replies
Oct 11, 2010
How can I manually populate a listview control without sql connection?
View 3 Replies
Jan 5, 2010
I want to insert an extra row in the gridview in the RowDataBound event (or another place if thats possible). How can I do that?
The data in the row to be inserted is not part of the resultset, but rather to split the gridview in logical sections.
View 19 Replies
Jun 16, 2010
I got a data like this :
ID
Url
1
c:a.jpg;c:.jpg
when I bind it into gridview, i want it to be like this:
ID
Url
1
a.jpg
View 5 Replies
Jan 28, 2011
how can I create a datalist manually, and bind it to my data source by code not by wizard
I use ASP.Net, Using C#.Net , and SQL Server Data base
View 3 Replies
Sep 7, 2010
I don't want to databind a gridview, I want to be able to add rows myself within c# code. I can see there is a GridViewRow object and wondered if I can use this to add/remove rows as required?
View 5 Replies
Mar 3, 2010
I am having a hard time updating from my gridview based the value that I am setting in the datakeynames it is the Ucc field I keep getting and index out of range exception on the e.keys[0]. I have done this before so I am confused what I am missing here.
View 8 Replies
