Recent content by le1234

thanks for the responses! SQL Scholar - I like the breakdown to seconds; this looks much better. simian336 - I want to be able to work out the Open Hours and mins between the 2 datetime fields for each record, which I can get but then work out the average open time for the whole dataset...

currently trying to extract the time difference bewteen two date time fields and then work out the average on the results. I can pull out the hours and mins between the two datetime fields using convert however if I try and run an average I get an error as its not a number value field. can...

no worries I found what I was looking for: -i Turns off interactive prompting during multiple file transfers. -s:filename Specifies a text file containing FTP commands; the commands will automatically run after FTP starts.

great thanks for the help - this has worked for me. can i asked what are the -i and -s switches? thanks again for your help

i would like to create a batch file that connects to an ftp area and picks up a txt file and places in a directory specifed on the C drive....anyone help with the code required... I have made a start but all it does is load ftp via cmd prompt. Any help would be really appreciated - I need to...

Thanks for you help so far - I set the flag to Run64BitRunTime = False and I can now run the SSIS package successfully in VS and Management Studio however when I schedule as a job I still get the SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error. any further ideas? I have...

connection 1 is the connection to the access db (if I open that connection I can see the database I am wanting to import). all work carried out on the server server is 64bit Thanks

I have a DTS package that has been migrated to SSIS (basically it pulls data from a table in and access db and dumps into a sql db table) - I have updated the connections as required and tested that they work correctly (I can preview the data within the access table that I want to copy over)...

that was exactly what i needed. Many Thanks

thanks ca8msm, i am trying to put this method into a query so that the difference will be calculated for the multiple rows returned. So i put the field name in the set statement instead of a specified date, but I get an error......can you recommend another way?

i need to be able to calculate the difference between to dates and show the results as hh:mm:ss

i did think that might be the case. i cant take the : out as that is creating the hours and minutes that i need. not to worry. thanks for your advice

totaltimeuser is producing the total time spent per user the calculation used is as following (got a group on per user and this total is in the group header) =trim(str(int(Sum(Fields!NumDuration.Value)))) + ":" + trim(str(int((Sum(Fields!NumDuration.Value) - int(Sum(Fields!NumDuration.Value)))...

thanks for the suggestion. tried this but is still coming back as #Error, I also get the following output message: The value expression for the textbox ‘percentage’ contains an error: Input string was not in a correct format.

not sure if this is at all possible but i have two text fields 'totaltimeuser' and 'totaltimeteam' on my report that do various calculations and display values. i then want to be able to do a further calculation using the results from these two fields. =("totaltimeteam"/"totaltimeteam")*100...