I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

    Sqlbeg5 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 pointsBadges:
  • ILE Call(e) error handling

    I am calling a CMD from an ILE program (simulates WRKSPLF) that emails a spool file. In my program I use Call(e) and %error indicator is on when CMD is executed if an error occurs during execution however I cannot determine which error happens. I tried using psds sds msgid 40 46 msgdsc 91 170...

    filuphaze475 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • PE Production environment

    When configurinf a new account how to change from quality environment (QE1) to production environment (PE1) in SAP

    Msilva5 pointsBadges:
  • SQL Error

    SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000

    Odunsi5 pointsBadges:
  • Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?

    Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.

    Ansipar288315 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Crystal Reports 8

    To Change The position & property of the Text in the crystal report from VB.NET code itself.... is It Possible??? while the Crystal report connected..... By Raam87

    12015 pointsBadges:
  • Round GPA to tenths and remove decimal in SQL

    I have a field in a table, ACT_OVGPA that represents a student's current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 - 4.0. This is what I have written, but it returns an error "too many values". Can...

    Cmyers40 pointsBadges:
  • What do the standard numbers mean in the National Electrical Code?

    What do the standard numbers mean in regards to the National Electrical Code (NEC)?

    NetworkingATE1,545 pointsBadges:
  • How do you tell Workflow to send an email to the initiator’s manager?

    I'm trying to create a workflow that will send an email to an employee's manager when that employee creates an expense report through the Portal. I've got the workflow set up and it currently sends to me when an expense report is created. So that part isn't really an issue. The issue is how do I...

    alm12180410 pointsBadges:
  • Finding the 3rd highest in the table using SQL.

    The table name is 'Employee' with the columns Empname Sal Age A 8000 25 B 7000 24 C 6000 26 D 9000 25 what is the syntax used to find the 3rd highest. I have tried with all the syntax but no gain. I have searched in w3schools.com but was not able to find the right answer. Kindly help.... Reks

    19757910 pointsBadges:
  • SQL Query

    Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08...

    Mariane10 pointsBadges:
  • Does similar ClearPool() from .NET Framework 2.x exist in .NET Framework 1.x

    I'm looking for a method similar to the ClearPool() from .Net Framework 2.x but this method must work in .Net Framework 1!

    alessandro.panzetta9,725 pointsBadges:
  • How to test Application scalability?

    What are the factors that need to be considered to test the scalability of the system? How do we ensure our application is scalable?

    Saimadhu455 pointsBadges:
  • How to test Application Robustness?

    What are the factors that need to be considered to test the Robustness of the system? How do we ensure our application is Robust?

    Saimadhu455 pointsBadges:
  • J2EE Web-based appllications

    Hi Im developing a J2EE application,when try to run this url--http://localhost:8080/ConAppl/editTaxi.html?id=1. It gives me this error javax.servlet.jsp.JspException: No form found under 'taxiForm' in locale 'en_US' does any1 have any idea with this error? Thank you in advance

    Development8875 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.