Recent content by 700503

have u tried to run the dtsrun command on the dos prompt directly? Also what is the user account for running the store procedure? Is it the same account u logged on the windows? I got the same problem before as the sql account doesn't have authority to run in command.

Thanks

Thanks You very much! I have created a report to count number of trunk used per minute by the orig_time and term_time for each trunk record in calldetail.

Chris13, Can you share how to build a canvas for custom-view to show usage of a trunk-group as a graph in 1/2-hour intervalls. Thanks Samuel

I want to have it. Can you send to me at wfyeung@hotmail.com. Thanks Samuel

For question 2, if you want to add calldetail, why don't you modify the 'Agent Perfomance (Detail) Report' instead? For question 1, what do you change on the formula? MISC1 and MISC2 are the field for network interqueue calls. Please provide more detail.

jocago, hello, I am interesting how to write a vb to update the output filename. Can u provide more information? Many Thanks Samuel

Dear all, Just a stupid question. Where can I find out the exam. schedule/location? I am in Hong Kong. Any exam in HK? Many Thanks

thanks, currently i am using the same tech to extract data based on sql by condition on the term_date. it is fast but still taking around a few mins to complete. as we have over 10 sites, the volume of data is also growth. I am afraid it will take too long to be done. moreover, the most hard...

One more finding is that calldetail in SQL2K will set as view instead of table. I don't know why it is located/classified as view. Moreover, I have an question whether we can copy the data from call_today instead of calldetail (a big table). The problem is how to ensure the full data copied...

Moebius01, Yes, I extract data daily from calldetail table in SQL2K and no error encounters so far. I just setup ODBC connection to the oracle and then setup a DTS package to import the data. By using the link server, I am not sure whether it works or not as I am not good in SQL2K. Regards...

in this case, i think Ibass solution is better.

I am note sure if this can help. Can I suggest to put 1 more group/order by date for each person? If you group/sort the record by date in desc order, then the first record will be most recent record. group by id group/sort by date in desc order print the first record when id...

Hello jestrada101, sorry to jump in. Would you check the command 'select expert' under the report in the menu bar? If the selection criteria for date is not there, please setup it.

Thanks you very much. I will check with my colleagues.