Ivan Mohapatra (10/27/2010)

---

Dear ,

Chk the File Format From where ur Importing the data to the database and then chk ur Path which u have provided .There r u type of...

Sorry I dont know what you mean, how would this be one?

Ah yes, I wondered...

Yes, I double checked that first 🙂

I tried using the out commands and that worked by exporting a table into a text file.

Would it be a better idea to import...

Yes, I created the C:\BCP\ folder for this

Thanks guys, I've had a read of the etiquette of posting and will repost and see where I get.

Thanks for help so far.

Thanks for that but when I put PARowNumber = 1 then it returns invalid column name

Excellent thanks for that 🙂

Its a bit simple really, was having a bad day yesterday 🙂

Ok thanks, I used that in the view, and then created a query from this to then show me the max(rownumber) in the hope it would only show me one...

has anyone any ideas on this as I'm still struggling changing the dates looking back

Thanks so much for this I have now found who the culprit is 🙂

Apologies, I realised that afterwards.

I tried the TMyDB in SMSS and BINGO it works 😀

Brilliant, I am chuffed to bits, I...

I tried the tnsping again and these are the results.

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\lislj>cd

C:\>E:

E:\>cd E:\Oracle\product\10.2.0\client_1\NETWORK\admin

E:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN>tnsping @TMyDB

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 -...

Do you mean this below in SMSS?

For the linked server in data source use “TMyDB”

dweil (2/4/2010)

---

Actually you can replace the tnsnames in \db_1etwork\admin with the tnsnames in client_1etwork\admin.

The linked server name does not mater but the data source has to be correct, might even...