Here is my code:

BULK INSERT [ThomasSci].[dbo].[DONNAWESNERINP]

FROM '\\111.17.10.23\global$\Stocking_Request\_macro\WESNERINPUT.txt';

GO

and here is the error message i get:

Msg 4861, Level 16, State 1, Line 1

Cannot bulk load because the file "\\111.17.10.23\global$\Stocking_Request\_macro\WESNERINPUT.txt"...

I tried both of those options and it didn't work. So that is why I am asking if anyone has run into this issue.

worked like a charm. Thank you very much.

Thank you very muck. Worked like a charm.:-D

I get the following error:

Argument data type ntext is invalid for argument 1 of replace function.

Never used powershell. Is it something that is easily learned and can be done?

No, has to go to an ip address and need to use a user name and password.

John,

Maybe I am doing something wrong with it. I need to copy the files that each section outputs to a server which has a log on and I am not...

I believe so. What I need is for the script to have the username and password in it so that when the files are transferred to that server, it wont...

Ok all,

Want to thank you for all your help. I have another question though. The output from the code gives me a .csv but the leading 0's are cut off...

Got it to output. Now just have to set up the data to to display as currency if it is, also keep the leading '0s' in the data and also...

That's all in the image. doesn't give me any error or anything else.

So here is my updated code:

-- Declare the variables

DECLARE @CMD VARCHAR(4000),

@DelCMD VARCHAR(4000),

@HEADERCMD VARCHAR(4000),

...

I did notice that after I posted. However when closing that, I got the following error message even though these are temp tables.

Msg 2714, Level 16, State 6, Line 22

There...

Brandie,

Thank you for that. I will have to try to set up DBmail first. I don't believe we have that set yet. A lot of reports and just run and...