Greetings,
I'm seeking help troubleshooting a script exception error in SQL Server Agent.
I've created an SSIS package in Visual Studio to backup database (Access and SQL Server) and other files from a directory in server A to server B. I then scheduled a SQL Server Agent job to run the package overnight using a SQL Server Agent proxy.
However, I can't get the job to run due to the following error message:...
jmartmem
Last Activity: Nov 2 '11, 06:34 PM
Joined: Feb 12 '08
Location:
-
SSIS package script exception: device is not ready
-
Very clever, Jared. I didn't think of that. I put an apostrophe in the result set code and it works. The apostrophe appears in the field, but at least I can see the value now. Thanks. -
ASP export to Excel - text formatting problem
Greetings,
I have a Classic ASP-based webpage that, on the click of a button, generates a dynamic result set that exports into Microsoft Excel using the following method:
There's one field in the Excel export that gets messed up because Excel reads it as a number, not text, so it looks like this: 9.1561282123729 7E+21. The field displays...Code:<% Response.ContentType = "application/vnd.ms-excel" %>
-
I'm running Windows Server 2003 R2, which means I have IIS 6.0. How do I use IIS to allocate more memory to my application?Leave a comment:
-
I haven't because it's my understanding that you can't change the buffer size. How would I go about setting the buffer very high?Leave a comment:
-
Resolving 'Response object error: Unable to allocate required memory"
Greetings,
I have a webpage that, on the click of a button, generates a dynamic, Classic ASP-based result set that exports into Microsoft Excel. Some of my result sets exceed the virtual memory maximum, and I get the following error:
I've turned off...Code:Response object error 'ASP 0100 : 8007000e' Out of memory /CIMS/ExportToExcel_TrkgCust.asp, line 0 Unable to allocate required memory.
-
How to extract part of a string?
Is there a function, or a combination of functions, in MS Access 2007 that will allow me to extract part of a string?
I have a database text field "Email" that contains a person's name and email address enclosed in brackets. Not all field values have a name, but each has an email address contained by brackets. Here are 3 example field values:
John Smith <johnsmith@emai l.com>
<marysmith@emai l.com>... -
It doesn't matter how I make it work. A colleague had suggested an "onblur" event, but I'm not required to use it. I have some experience with JavaScript, but not much. However I can get the text boxes to sum will work for me. Any suggestions?Leave a comment:
-
Should I re-post to the JavaScript forum?Leave a comment:
-
How to AutoSum text box values in a separate text box
Greetings,
I'm developing an ASP.NET web page, which includes three text boxes for users to enter customer revenues. I want to code a formula such that the value in the Total Revenue text box (txtRev_Expr_To t) equals the sum of values entered in the Current Revenue (txtRev_Expr_Cu rr) and Incremental Revenue (txtRev_Expr_In cr) text boxes. I also want the Total box to update in OnLostFocus events from the other two boxes.
... -
PROBLEM RESOLVED. I figured out what the problem was. I'd omitted on onChange event in list A for list C. It now works as designedLeave a comment:
-
Troubleshooting client-side dynamic dependent list boxes
Greetings,
I have a nagging problem with client-side dynamic dependent list boxes that perhaps someone can help me troubleshoot.
I have a form with a series of dynamic dependent list boxes. Making a selection from list/box A (Qtr) selects a fiscal quarter, which then refreshes the values in list/box B (Mth), which shows the 3 months in that fiscal quarter, which then refreshes the values in list/box C (MthDate), which... -
That's correct. All I want the function to do is change which option is selected in the second list/menu.
JM
P.S. Thanks for moving the thread. I didn't realize it wasn't in the Javascript forum.Leave a comment:
-
Greetings,
I started this post several months ago and want to revisit it now as I'm ready to troubleshoot this issue.
I want to use Javascript to make this work. While I'm far from a Javascript expert, I took a stab at writing the code, which I've posted below.
...Code:<SCRIPT language=JavaScript> function datechange() { (document.form1.Status.options[document.form1.Status.selectedIndex].textLeave a comment:
-
That did it! It's usually something simple that I overlook.
Thanks, acoder!
JMLeave a comment:
-
Okay. I corrected that but it's still not working right. Now when I click the submit button I get an IE error on the page for line 9 that says, "document.form1 .entrydate01 is null or not an object". I get this error even when there's a date in the text box
Here's the updated code:
...Code:<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Leave a comment:
-
I understand the concept, but I'm not sure how to write the code to convert the date input into a Date object.
To practice, I created a simple ASP page with a form that contains one text field and a submit button. For simplicity's sake, the text field value is initially populated with today's date.
I wrote two JavaScript functions to be activated onSubmit: (1) a check for a null value in the text field, and (2) the date...Leave a comment:
-
JavaScript function to check date field for future date
Greetings,
I have an ASP page with a form (form1) that contains a JavaScript validation function that is activated onSubmit. The function contains a series of IF statements to alert the user to any blanks contained in the form elements.
What I want to do is add a new IF statement to the function that checks whether the user has populated a date field (entry_date01) with a date that is in the future. In other words, the... -
I understand the concept of what you're talking about. Let me see if I can implement it. I'll post back if I have any issues (which I usually do).
Regards,
JMLeave a comment:
No activity results to display
Leave a comment: