Bill/Phill,

You guys are the best, I added the line that Bill suggests:

Insert into ##temp_ftp_bat values ('cd exports', @file_to_push)

And it all works sweet as, I cannot thank you two enough!

Thank you...

Phil, sorry for the slow responce, where abouts shout the bat file be, I thought it would be in the same directory as the file, but none is there?

Does...

Oh and before I go sticking my foot into my mouth again, both directories that I tried (blah & exports) both exist and have 750 permissions on them so this...

Phill,

OK well it's executing fine, but still not changing the directory. This is what I tried:

Insert into ##temp_ftp_bat values ('cwd blah', @file_to_push)

Insert into ##temp_ftp_bat values ('cwd /blah', @file_to_push)

Insert into ##temp_ftp_bat...

Phil,

Yeah it does help if I have shared the bloody directory, <bonks self>.

Well, it worked great, but when I added in the line to specify the directory like so:

Insert into...

Oh and might there be a way of specifying a directory to upload to on the ftp?

Thanks,

Cyrus Bharda

Bill,

Well ran the script and it executed fine, so I then tried this:

exec up_FTPPushfile '\\serevr\directory\blah.csv', 'ftp.com.au', 'username', 'password'

and got this error:

Server: Msg 50000, Level 16, State 1, Procedure up_FTPPushFile, Line...

Wow, great thanks for the help, only problem is that I am a noob and have no idea exactly what I am looking at for that script above, still trying...