Page 1 of 1
regarding target file creation
Posted: Mon Sep 11, 2006 12:59 am
by vijaya
Hi All,
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
please help me
Posted: Mon Sep 11, 2006 1:30 am
by vijaya
Hi all,
Please help me in doing this it is very urgent
Re: please help me
Posted: Mon Sep 11, 2006 2:13 am
by khaja.arshad
Just check whether the same table is not existing in u r database or else put the table name in uppercase
Hameed
Posted: Mon Sep 11, 2006 2:15 am
by kris_r
What is the exact error message that you are getting?
Posted: Mon Sep 11, 2006 2:48 am
by sb_akarmarkar
May be you dont have permission to create table... Take help from your DBA
Thanks,
Anupam
Posted: Mon Sep 11, 2006 3:47 am
by kumar_s
You should not urge people to answer, But the same time you should provide the necessary log information to others to investigate.
Re: regarding target file creation
Posted: Mon Sep 11, 2006 11:22 am
by prabu
vijaya wrote:Hi All,
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
maybe, just maybe....
Code: Select all
Tables can neither be created nor be destroyed but can be converted from one form into another
most of the times, the log message+google will do the trick for db related errors.
Re: regarding target file creation
Posted: Mon Sep 11, 2006 11:36 am
by kris007
prabu wrote:
maybe, just maybe....
Code: Select all
Tables can neither be created nor be destroyed but can be converted from one form into another
That is not completely correct. One can create table from within the ODBC stage and create/drop tables from the DB stages. Make sure that you are using generated sql and not user-defined sql. If you are still not able to, then post the error messages.
Posted: Mon Sep 11, 2006 12:15 pm
by DSguru2B
Kris, i think prabu was just kidding as he was re-iterating newtons third law of physics.
Posted: Mon Sep 11, 2006 1:18 pm
by prabu
Posted: Mon Sep 11, 2006 1:42 pm
by DSguru2B
Once again, Newtons second law, also known as law of intertia, or maybe, in your case, "law of distracted minds"
Posted: Mon Sep 11, 2006 2:09 pm
by kris007
DSguru2B wrote:Once again, Newtons second law, also known as law of intertia, or maybe, in your case, "law of distracted minds"
Actually, it's the First law
Posted: Mon Sep 11, 2006 2:19 pm
by DSguru2B
O yea, thats true. The second one was F=ma. Thanks Kris.
Posted: Mon Sep 11, 2006 4:11 pm
by ray.wurlod
What is the reason that you can not create the table? What error code appears in the error/warning in the job log? For example, do you have appropriate permission in the database to create tables? Did the DROP TABLE statement fail (which would cause a CREATE TABLE statement to fail)?
Re: regarding target file creation
Posted: Mon Sep 11, 2006 4:30 pm
by deepak.shanthamurthy
vijaya wrote:Hi All,
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
Guess the UserName you are using to connect to the ODBC target does not have enough privileges to create tables in the db schema.
Check db privileges for this user
