Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: xtreemnet
  • Content: Threads
  • Order by date
  1. xtreemnet

    Export to csv file

    Hi, I am trying to export the output from oracle query to a csv file using SSIS. I have the oledb source and a flat file destination tasks. The output of the csv file randomly strips the first few digits from the first field. Example as below: Query : select customerno, case when type = 'RT3'...
  2. xtreemnet

    Failure sending mail

    Hi, I have deployed a report using oracle datasource. The report when run from report manager works fine. But the subscription fails with error: Failure sending mail: An error has occurred during report processing. Have been trying to find solution but could not get one. Can anyone...
  3. xtreemnet

    Crystal equivalnet next and previous

    Hi Is there a equivalent function in RS for Next(field) or previous(field) for accessing data from next or previous row? Thanks.
  4. xtreemnet

    SQL query for CLOB

    Hi, I am trying execute the following SQL: select id, length(rec), dbms_lob.substr(rec, length(rec) ,1) from ITEMS WHERE ID = 'PROD' The length for 'rec' is 3832 characters. The query fails with message : 'ORA-06502 PL/SQL numeric or values error: Character buffer string too small' How do I...
  5. xtreemnet

    Create a connection to Oracle 10g on 64bit windows

    Hi, Can someone tell me the steps to create a connection to oracle 10g on a server which runs on Windows 2003 server(64bit)? I need to update a SQL 2005 table from data on Oracle 10g. Thanks.
  6. xtreemnet

    CLOB greater than 32767 characters

    Hi, I am extracting data from a text file which is stored as a clob in the table. I wrote a function to extract this information. It works fine for smaller files. It did not return anything for one of the clob which has has a file of size 142kb. I guess its beacuse of the size limit for clob...
  7. xtreemnet

    Report Definition option

    Hi, I just installed Crystal report 2008 free trial and found to that the Export report to "Report Definition" option does not exist in the drop down box. Can someone please let me know from where I can do this? Thanks,
  8. xtreemnet

    Package fails as SQLAdmin

    Hi, I ma importing a csv file into SQL table on my local server. The package runs OK from my local server when run through SQL server agent. But it fails when run after deployment to a network server and run through SQL server agent. When executed from the MSDB tree on network server it runs...
  9. xtreemnet

    SSIS package Fails

    Hi, I have created a SSIS package and deployed sucessfully on network server. I am trying to use Custom Log provider sample (HTML format). The package runs file from BIDS but when deployed on network server, It gives an error: "Executed as user: HAMILTON\SQLAdmin. The package could not be...
  10. xtreemnet

    Combining multiple queries

    Hi, How do I combine multiple queries as below into one row? Select count(a) as cnta from s; Select count(b) as cntb from t; Display them as one row as: count(a), count(b) Thanks,
  11. xtreemnet

    Macro for Text to column

    Hi, I have a fixed width text file which I am trying to import into Excel sheet. When I use Text-To-columns to import the dates are imported correclty(dd-mm-yyyy) as in the text file. However if I record a macro for this operation and then try to import the file, the dates are not imported...
  12. xtreemnet

    Export Access Table to SQL 2000

    Hi I would like to export an Access table to SQL 2000 through Visual basic 6. I have used OpenSchema method to get the deails of the MDB file, so I can select any table to export. Can somebody guide me please, Thanks,
  13. xtreemnet

    Access DB size grows large with update

    Hi I am updateing a access table with copying down a field as below: Table1: field1 fiedl2 aaa 12 21 52 def 20 36 and so on. The data above is brought from multivalued database (UniData). I am updating the blank values field1 with the one above. My...
  14. xtreemnet

    Linked server with UniData

    Hi I am trying to connect to UniData using linked server from MS SQL. I tried using the following details, but could not get the tables. It comes with an error that "UVI connections to non Universe database not allowed. product name: Unidata data source: c:\ibm\ud60\demo provider string...
  15. xtreemnet

    DOM to load XML

    Hi I am using DOM in Visual basic 6 to read a XML document. I am using msxml4.dll. I can read most of the documents. But one document gives an error : "Required attribute 'name' is missing". How ever If I disconnect my machine from internet, it reads without any error. Any idea why this...
  16. xtreemnet

    Shared variable not showing

    Hi I am showing 2 shared variables from a subreport into the main report and using them for calculation. Now I have added a 3rd shared variable to the main report from the subreport. It shows the value in the sub report part of main report. But if I try to show it in the section below it shows...
  17. xtreemnet

    IDAPI Error

    Hi I am using crystal report 8.5 and trying to create a new report with paradox database. When I try to select a table I get an error: "IDAPI error:No access to dir." I have BDE administrator installed. Any help is apprecited, Thanks,
  18. xtreemnet

    Display to user that processing is going on

    Hi I am reading a big text file and doing processing on the read information. I have a form where I browse to the file and then press a button "Process". On click method of this button I have form2.show. In the form2's load event I call a procedure called "ProcessDocument". The form2 has a...
  19. xtreemnet

    Launching takes lot of time

    Hi I have made an msi with wise for windows installer 4.2. The size of msi is 466Mb.It takes long time to start the installation. Is there any way to reduce this time. Thanks,
  20. xtreemnet

    Cannot the node list for an element

    Hi I am new to XML. I have a file with first few lines like: <?xml version="1.0" ?> <LandXML xmlns="http://www.landxml.org/schema/LandXML-1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.landxml.org/schema/LandXML-1.0...

Part and Inventory Search

Back
Top