Jeff

The below is the code i have used. This is exactly the same as the one you have sent except that i've changed the table name from tstperson to person.

I...

Jeff

I tried changing the path and made sure the path exists. I also made sure the user(sa) has write permissions to that folder.

But still no luck....

Thanks

Jeff

It is on the server...

Do i have to mention it as \\support_svr1\path?

Thanks

Vijay

Jeff

any luck? I have to finish this today! Your code will work once we eliminate the error i mentioned above.

With my code, i get the below error:

Copy direction must be...

Hi Jeff

Below is the ouput i get when i run only the lower part of the code you have sent (not the test):

 Volume in drive C has no label.

 Volume Serial...

Hi Jeff

Sample data:

id_number                              surname forenames 

002054.2003801645150037.001 Nicorescu Alina

002054.2003801732590187.001 Bularca Ionela Bianca

002054.2003801736180077.001 Bruno Antonio

002054.2003805417190443.001 BIESZKE-WIERZBA JOANNA

002054.2003805716460903.001 Suarsana I Kadek

Create table statement for person table

CREATE TABLE [PERSON] (

 [ID_NUMBER] [nchar] (27) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [PRFSCID_CODE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [PLEAVE_RTYPE] [nvarchar] (15) COLLATE...

Hi Sreejit

thanks for your response. i tried to print the cmd and i got a syntax error saying ' incorrect syntax near .001' as the id numbers are of the...

Hi Jeff

I used variable though u initially suggested column name as i know i'm using a cursor (i know it is a bit...

Hi Jeff

Thanks for your response. But it is not creating even one file now let alone all the files.

Looks like the cursor is not looping through the bcp line of the...

Guys

any ideas on the above? i'm desperate now!

thanks

Sorry Jeff

i'm late in replying... i appreciate your help.

the primary key for the person table is id_number.

and i have the following code:

this code is not working - creating only one...

Hi Jeff

Any chance of the code?

thanks

thanks guys..

i managed to do it...

DECLARE @cmd VARCHAR(5000)

SET @cmd = 'OSQL -S support_svr1 -d NCLREMOTE_SP6D '

    + ' -U sa -P seaward'

    + ' -Q "select notes...

Hi jeff

i tried below but can't get round it. Please help.

DECLARE @cmd VARCHAR(5000)

SET @cmd = 'OSQL -S support-ts2 -dNCL_REMOTE_SP6D '

    + ' -Usa -Pseaward'

    + ' -Q"select...

someone pls help!!!!!!

do i have to use insert ... select?

thanks