• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Issue with tSybaseOutput Action on Table

#1 2009-10-16 22:52:26

siva
Member
Registered: 2009-06-24
Posts: 31

[resolved] Issue with tSybaseOutput Action on Table

Tags: [sybase]

I have a job in TOS v3.1.2 that extracts data from a sybase database, processes the data and writes the data to an xml file. I am using a tSybaseOutput component to create a temporary table to store the records to be processed by the job. I have the following configuration for the tSybaseOutput component:

TableName : tempdb..test
Action on Table: Drop table if exists and create
Action on Data: Insert

However the job/component is not deleting the temp table if exists. I am getting the message (tempdb..test already exists).

Not sure if i am missing something...please advice.

Offline

#2 2009-10-19 08:02:37

shong
Talend team
Registered: 2007-08-29
Posts: 10299
Website

Re: [resolved] Issue with tSybaseOutput Action on Table

Hello

TableName : tempdb..test

Don't add some dot '.' in your table name.

Best regards

         shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2009-10-19 22:29:58

siva
Member
Registered: 2009-06-24
Posts: 31

Re: [resolved] Issue with tSybaseOutput Action on Table

Yes, got it fixed...thanks

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Issue with tSybaseOutput Action on Table

Board footer

Powered by FluxBB