Talend Job is taking more time to complete execution

[Rajkumar_J]

Hi,

I am working on TOS. In this i have created a certain number of jobs and done schedule through 'windows task scheduler'.

My problem is, sometimes the job is getting completed within 2 mins and sometimes the same job is taking more time (approx 2 hrs) to complete the execution.

What is the reason for this and how could it be rectified?

[manodwhb]

@uganesh ,tmssqloutputbulk  will create a Bulk file to load into DB,so may be you may not have access to create BULK file ,please check the access to create a file in that location

[Rajkumar_J]

Now i can able to create a file based on bulkload, but i have to load it into sql table.

At the time of loading the data with tmssqloutputbulkexecution component and i am getting the same error.

"You do not have permission to use bulk load statement". It seems that, do we need to enable any settings in sql database level?

[manodwhb]

@uganesh ,yes in DB side you need to do I belive

[Rajkumar_J]

@manodwhb, While using bulkload component for sql, i am facing one problem.

The data type boolean is automatically converting into "true,false" in the text file before loading to the output table. So the data can't be loaded in the target.

[manodwhb]

@uganesh ,Yes for the Boolean values it should be true or false. what is your target DB type? based on your DB allows you need to manage that filed as string.

[manodwhb]

@uganesh ,if i understand correctly you need to convert true to 1 and false to 0 .

[Rajkumar_J]

@manodwhb, yes...i need to convert true to 1 and false to 0. Because my target data type also boolean.

[manodwhb]

@uganesh ,where you were creating true/false,you can generate 1/0 but the o/p column data type should be string.

[Rajkumar_J]

@manodwhb, my understanding correct means, there is no data type called 'boolean' while making bulkload right?

[Rajkumar_J]

@manodwhb, but my need is boolean data type.....so do any other way to reproduce the same in text file also?