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.
Could not see the table while importing the table in DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am
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.