Search results for query: *

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...

...+ ':' + CAST(FLOOR((DATEDIFF(mi,[Open Date & Time],[Close Date & Time]) / 60 - FLOOR(DATEDIFF(mi,[Open Date & Time],[Close Date & Time]) / 60)) * 60) AS varchar(2)) AS castHourMin, CONVERT(varchar(10),DATEDIFF(mi,[Open Date & Time],[Close Date & Time])/60) + ':' +...

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

...header) =trim(str(int(Sum(Fields!NumDuration.Value)))) + ":" + trim(str(int((Sum(Fields!NumDuration.Value) - int(Sum(Fields!NumDuration.Value))) * 60))) totaltimeteam is producing a total of time spent by all users, using the same calculation as above, is at the top of my report out of the...

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.

...and display values. i then want to be able to do a further calculation using the results from these two fields. =("totaltimeteam"/"totaltimeteam")*100 the report still runs but I get an error appear for this text field value. Am i doing something obviously wrong or is this something that...

sqlserveragenterrorlog: [LOG] Unable to send job completion notification email to operator 'BOPSQL SQLBackup' for job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan FULL BOPSQL'' maintenance log looks ok, no errors logged until the last line: End of maintenance plan 'DB...

that is the message in the maintenance history.

currently have an optimization job with 1 step which keeps failing. When I view the job history all i get is the following error message: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. Is anyone able to help?

thanks again for your help, will do some further investigation

thanks for the reply, the error I am wanting to trace is 'Invalid buffer from client, Error: 17805, Severity: 20, State: 3'.