regarding target file creation

vijaya · Post by **vijaya** » Mon Sep 11, 2006 12:59 am

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

vijaya · Post by **vijaya** » Mon Sep 11, 2006 1:30 am

Hi all,

Please help me in doing this it is very urgent

khaja.arshad · Post by **khaja.arshad** » Mon Sep 11, 2006 2:13 am

Just check whether the same table is not existing in u r database or else put the table name in uppercase

Hameed

kris_r · Post by **kris_r** » Mon Sep 11, 2006 2:15 am

What is the exact error message that you are getting?

sb_akarmarkar · Post by **sb_akarmarkar** » Mon Sep 11, 2006 2:48 am

May be you dont have permission to create table... Take help from your DBA

Thanks,
Anupam

kumar_s · Post by **kumar_s** » Mon Sep 11, 2006 3:47 am

You should not urge people to answer, But the same time you should provide the necessary log information to others to investigate.

prabu · Post by **prabu** » Mon Sep 11, 2006 11:22 am

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.

kris007 · Post by **kris007** » Mon Sep 11, 2006 11:36 am

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.

DSguru2B · Post by **DSguru2B** » Mon Sep 11, 2006 12:15 pm

Kris, i think prabu was just kidding as he was re-iterating newtons third law of physics.

prabu · Post by **prabu** » Mon Sep 11, 2006 1:18 pm

DSguru2B wrote:Kris, i think prabu was just kidding as he was re-iterating newtons third law of physics.

good to see a serious response on this

the world of missing smiles

Code: Select all

Every person in a state of uniform [rational] mind tends to remain in that state of mind unless an external  [b]nut case[/b] triggers him

DSguru2B · Post by **DSguru2B** » Mon Sep 11, 2006 1:42 pm

Once again, Newtons second law, also known as law of intertia, or maybe, in your case, "law of distracted minds"

kris007 · Post by **kris007** » Mon Sep 11, 2006 2:09 pm

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

DSguru2B · Post by **DSguru2B** » Mon Sep 11, 2006 2:19 pm

O yea, thats true. The second one was F=ma. Thanks Kris.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 11, 2006 4:11 pm

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)?

deepak.shanthamurthy · Mon Sep 11, 2006 4:30 pm

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

DSXchange

regarding target file creation

regarding target file creation

please help me

Re: please help me

Re: regarding target file creation

Re: regarding target file creation

Re: regarding target file creation