Thanks Brandie, that solved my issue. 🙂

Dan

Hi

Tried without the no output. But no error meassge.

Also I started command promt and typed it in as plain command

That works just fine.

Dan

Hi

That would leave me with week 0 when it returns week 1.

.

Dan

Hi

In Norway this is week 25.

Dan

Thanks Ken.

Your code works fine. Tried both to test speed, but the I have to small amount of data to get any good reading.

Dan

Hi

We have several Oracle tables that I going to extract to our MS SQL 2005 datawarehouse for business modeling.

I just did one test where I created a DTS 2000 package...

No. I have not used that one. Our app does ot support .Net I think.

But ca you forward me to a site where I can find more info ?

Dan

Hi

We use Oracle odbc OraClient 10_gHome based on InstantClient_11_1

Dan

Oracle support may say this is not a problem but a feature, let me explain.

varchar2(100 byte) means the column stores single-byte characters to a max of 100 bytes.

varchar2(100 char) means...

Thanks Mark.

That was just brilliant.

Short end efective.

Dan

No proxy

Hi Steve

Yes the user for sql agent is the same as my login user to both the sql server and the file server.

Dan

Hi

I can create a copy of the table yes, but I can not figure out how it is linked.

A copy is static, and I need a dynamic one. Linking therefor...

argggghh, I was sitting here minding my own business and writing a reply to your post and pushed post reply, when it all went down the drain... Damn...

Terry: "(..)then you need to give proper access permission to the SQL-Agent login for those files."

The notes database is on another server yes. I have set up an odbc and...