OK Thank U

OK, now work...this is the rigth codes.

Tnks for support anyway...

use Directory.GetFiles() for my array of string file.

http://ftp.SendFiles(Directory.GetFiles(strPathDirectoryLocal & "\" & strNomeCartella), "/imports/SSIS/" & strNomeCartella, True, False)

Thanks for your answer...but I don't want use 2 time conection on http://FTP...so I solved using an ASP.NET script....but your tip of * and ? are an valid...

Thanks...I never use this kind of syntax...

Close but no cigar....

There is something of wrong on the order clausole...but I have learn something of new with your example....

THSNKS anyway...

Thanks RAmesh...but always have an eror on compile... R U sure??

----

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[fnGetConselRow] (

@Prezzo int,

@Tasso0 int,

@Skuint

)

RETURNS TABLE

AS

RETURN (

SELECT TOP 1 *, @Sku...

Thanks but was an error in my code...there is an different ORDER BY if Tasso0 = 0

see belove

----------

ALTER FUNCTION [dbo].[fnGetConselRow] (

@Prezzo int,

@Tasso0 int,

@Skuint

)

RETURNS TABLE

AS

RETURN (

-- Ha...

Yes don't run...

Can U explain me better please as I can index that column?

I use this soluction for the function...

SELECT

MAX(IDconsel)

FROM sqltest.ePrice2K5.dbo.Consel

WHERE imp_fin <= @Prezzo AND tasso0 = @Tasso0

So...there isn't other way for elude TOP in the query?

this is the focus of the query...there are many other table on JOIN...but belove in the example is my problem.

Must be something like under...but I can't use variables...on the...

Perfect this is my solution...

Thanks

Hi Matt,

thank for your response.

It was very usefull but I think wrote wrong example for post.

I must split a Value for OUTPUT into script task into the data...

Ho tommy,

i've found this sw and I try but always have problems....

psexec \\manny-slave "E:\Eseguibili\PayPal_getTransaction.bat" -u manny-slave\Administrator -p myPass

Is correct this syntax...the bat is a path to a .VBS file for...

No difference...I try a differt provider too....always error

If I logging with windows application log run but is not my need...

I want store into DB.