Recent content by xtreemnet

Thanks. That helped. Except I kept the Oracle driver same but cast the customer to nvarchar2.

I am using the oracle provided driver. The customerno is numeric and the type is nvarchar2. When I add the data viewwer on the link from oledb and flat file destination the data looks ok.

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'...

Thanks.

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...

I am just trying this in the detailed section

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

If I use just substr then the substr just returns null: SQL> select id, length(rec),substr(rec,32768,1) 2 from items 3 WHERE ID = 'PROD'; ID -------------------------------------------------------------------------------- LENGTH(REC) ----------- SUBSTR(REC,32768,1)...

I just tried the below and still getting the error: SQL> SET BUFFER 100000 SQL> select id, length(rec), dbms_lob.substr(rec, 32000 ,1) 2 from items 3 where ID = 'PROD'; select id, length(rec), dbms_lob.substr(rec, 32000 ,1) * ERROR at line 1: ORA-06502: PL/SQL...

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...

This is getting very funnuy. When I test my connection manager it fails. But my Execute SQL task which uses this connsction works fine. I have created another similar connection manager for Oracle and try to assign it to an oledb component, and it errors out saying 'Cannot acquire connection...

Hi, I can now execute SQL task which uses oracle 10g connection. But i have not been able to connect to an oldeb source component using the oracle connection manager. Any help is appreciated. Thanks

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.

Hi no worries. I have no privilages to modify the table. I have found another temperrory solution. Instead of passing the whole file, I will find the start position of the srch_str VARCHAR2 parameter in the select query and select the substring of about 500 characters and then extract the...

Hi theargtheslayer, I am running this from Oracle's free SQL Developer interface. The table is oracle 10g. For your information if I paste my file in the clob variable the following error is returned: declare rec_string CLOB := 'Paste my file here'; ret_str VARCHAR2(4); len integer...