thanks for the quick response but it still returns [N] at the beginning whereas the results should be

18. Is the C.B. removed from the panel?

one other thing is that...

it worked like a charm

thank you so much

YOU ARE SUCH A STAR

thank you so much i didn't realize i was overwitting the ouput, it works perfectly now!!!!!

i've tried creating a static output file but now only one file is loaded in the the destination

i've build connection path variables -

ImportSourcePath = C:\OnKeyImports\WorkOrderCosting\Source\

FilePrefix = WorkOrderCosting

FileExtension = .txt

and build it in the connection string like this to add date in the file name:

...

i'm getting multiple files outputs whereas i want to combine all my input to a single file.

here's what i'm doing. i have multiple files e.g Item1.xml, Item2.xml, Item3.xml, etc....

thank you for the response

here's my output path C:\OnKeyImports\WorkOrderCosting\Source\WorkOrderCosting_20130419_100035.txt

the expression on the connection string is @[User::ImportSourcePath] + @[User::FilePrefix] + "_" + (DT_WSTR,4)DatePart("yyyy", GetDate()) + RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()),...

thanks for the quick response.

is there a code that i can use to convert .tif to jpg dynamically for displaying purposes.

thanks guys for all the responses really appreciate it and i managed to get it.

hi guys

thanks for the response, i realized that i won't be able to get the Max(TimeTo) since the transactions happened on the same date and same time.

i have another query...

hi Jeff

i came across this post:

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = '20070429',

@DateEnd = '20081201'

--===== Find the...

you are such a star....

it worked perfectly, i only had to change the minus to plus sign here: AND cte1.row_nr=cte2.row_nr+1.

thanks a million

thanks, it worked perfectly

hi Chandu

you are such a star... that's so much

thanks again

i've decided to create two reports for each server... i've got one other problem though if you could assist,

can you look at the code below

what i'm trying to achieve...