Please help me clearify...

[aaronej]

All,

Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate statement to the DB or does it do somekind of Delete logic. I am working with my DBA to get appropriate rights for the user we will be using to run our jobs and this will make a difference. We run SQL Server 2000.

Any help would be apprciated.

Thanks!!

Aaron

[1stpoint]

Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate statement to the DB or does it do somekind of Delete logic. I am working with my DBA to get appropriate rights for the user we will be using to run our jobs and this will make a difference. We run SQL Server 2000.

Aaronej,
The option "Clear table and Insert Rows" does a Delete From <table>. The option "Truncate table and insert rows" performs a truncate.

[neena]

Hi
Clear table and Insert Rows uses the Truncate as of my knowledge.
Thanks,
Neena

[kcbland]

There is no TRUNCATE on ODBC stages. It is Clear table blah blah blah and that is a delete from statement.

On an OCI stage such as Oracle, you do have both Clear and Truncate options. They are radically different in permissions (Truncate requires you to have alter table permissions where Delete doesn't).

So, everyone sing it together....

Truncate is truncate and clear is delete
Now my ETL life is complete...

[aaronej]

Thanks for all the help! I like the poem.

--Aaron

[Teej]

Is it me, or is there some weird formatting issues on this particular thread?

I don't have any HTML diagnosis tools here (It've been 4 or 5 years since I did some serious HTML work), but it appears that there's an extra <table> defined.

Man, this tool sure depend heavily on table formatting, instead of CSS.

-T.J.

[chulett]

Is it me, or is there some weird formatting issues on this particular thread?

It's just you.