DSXchange

Hi ,

I have requirement to load the data from source table to a temporary table. I created a table, and am able to select,describle it in Database. But when I try to import the table definition through DataStage, I could not see the table.

Even, when I run the job by defining table definition manually, its aborting with the below error:
Write mode failure: Table_Name doesn't exist.

Could you please let me know, where the issue is .

Thanks,
Anand.

Did you create a local or global tmp table?

Hi Sussane,

Thanks for your quick response.
Its a global temp table only. I have already created such tables, which were importable. But this alone is creating a issue.

Thanks,
Anand.

...and your user are still connected to SQL server when you try to import the table?
...and the DS user have the right permissions for the database?

suse_dk wrote:...and your user are still connected to SQL server when you try to import the table?
...and the DS user have the right permissions for the database?

Hi Sussane ,

Thanks for your support.
Actually, there was change in the DSN of the Database. New DSN has been added. Now its resolved.

Thanks,
Anand.