I cannot use this

select *from TableA A

, TableB B

where B.reference = substring(A.trad_type,1,6)

because the reference could be SL997599 or SL9975586666 so substring won't work

Here is the code

The code is from the guy called Nigel Rivett

CREATE procedure ISL_FTP_PutFile

@FTPServer varchar(128) ,

@FTPUser varchar(128) ,

@FTPPWD  varchar(128) ,

@FTPPath varchar(128) ,

@FTPFileName varchar(128) ,

@SourcePath varchar(128) ,

@SourceFile varchar(128) ,

@workdir varchar(128)

as

/*Please Maggy do not forget to use no_output so that...

I managed to get this and it works like a bomb

Hi Guys

I got an answer from

http://www.nigelrivett.net/s_ftp_PutFile.html where Nigel use used Put, I had to use Get since I am getting this from remote server. ...

Thanks once again Dave, where did you learn SQL or maybe how?  Please give me an indication because I am relying mostly on help...

Hi Dave!

I am a newbie when it comes to SQL, sorry for inconvienience, your answer worked perfectly, but  I meant to say minutes

With your above answer, can you change that...

Thanks, David, you are a star

You can get arround the limitations of getdate() within UDF by creating a view:

create view dbo.vw_getdate (CurrentDateTime) as select getdate()

select * from  dbo.vw_getdate (CurrentDateTime)

go

Then you can use this view within...

I still don't understand what to do, I am a newbie when it comes to UDF

I answered myself, for those who have the same problem, this is what you can do, alter a column so that the collations are the same

ALTER TABLE TestTab ALTER COLUMN...

Hi Pete

Thanks a lot, I also used xp_cmdshell.

Both of us are still using a manual process.  I want something that will check if the new files arrived and schedule a job or...

Ok Steve, this is my code in the table trigger, and it takes the parameters to the dll.  I didn't write the dll it was writen by the vendor, but...

I used ALL CAPS, but still got the same error.  I don't think you can call Oracle store proc from SQL

Yes I did and I get this error

Could not process object 'call FM.TDP_LOADER.insert_exec_alloc()'. The OLE DB provider 'MSDAORA' indicates that the object has no columns.

OLE DB error trace [Non-interface error: ...

Thanks