SQL transform doesnt work as usual

[former_member610952]

Hi All,

So I happened to notice something strange this morning. When I use an SQL transform as a source in my job, it doesnt display any if it properties.

The screen is just blank as below. What could the reason be??

I attached the image for reference.

Sindhura Thota

[akhileshkiran]

Hi ,

if this is an existing job can you try to execute the job once and post the error. Try to re-import the job if you have a .atl file.

Can you provide more information about the environment you are working on.

Regards,

Akhilesh Kiran.

[former_member610952]

Hello ,

This is for an existing job which failed due to an error in the SQL where clause. When I try to edit the where statement, there is option where I can do it. I tried acreating a new job using SQL as source and its the same issue.

The job is in Dev environment.

[mageshwaran_subramanian]

These might help.Open the designer as an Administrator or restart the services and try again.

[akhileshkiran]

Hi

Are you  facing this issue in the Client Tools? If you have any another development local repository try to import job from your LR and check there.

can you provide me the following details:

Data Services Version with Support Pack :

Database of Repository:

Which database type you are trying to connect in the SQL Transform:

Regards,

Akhilesh Kiran.