Do you mean ipaddress\instance in the server name? Are you sure you have the correct IP Address and and instance?...

Why can't you just use SUM? The data you show looks like it is hours and decimal part of the hour (2.67), not seconds so a SUM should work....

Nice find on the Link, Gift. That should work.

What does the data actually look like in SSRS? You should be able to use a custom function to format it appropriately.

Are there any error messages in the error log?

Is "S" a mapped drive? Since the SQL Server Agent account is not "logged in" to the server the drive is not being mapped. Try using the UNC...

First you need to determine what dates are holidays and weekends. Do you have a dates table that defines this information? While it is possible to determine what...

If it has an OLE DB driver you should use that. If not, install the ODBC driver, create a DSN, and use the Microsoft OLE DB Driver for ODBC...

Please don't cross post. Post replies here, http://www.sqlservercentral.com/Forums/Topic657319-391-1.aspx

Please don't cross post. Post answers here, http://www.sqlservercentral.com/Forums/Topic657164-359-1.aspx

Could you post your actual tables with some test data and the results you are looking for? It will be easier to make suggestions with this information.

Here is a link to how to use the Conditional expression in SSIS, http://msdn.microsoft.com/en-us/library/ms141680.aspx

Good article Gail. Stuck it in my brief case. I just hope I never have to reference it to fix any of my DB's. 😀

What is the actual source of the data? Is it Access, SQL Server, Oracle, MySQL?

raviq123 (2/12/2009)

---

I was trying sql server 2000 import/export data utility and getting those messages. They are not free foxpro table, they are real table and some of those table can...