I am easily able to format the date when it is in a character format; however, I want to convert from its original format interger field to a datetime time...

I'm sorry I don't remember how we fixed it. Its working now. I'm thinking it had something to do with deteting the user in the database list of users. Sorry...

The date will always be in the format YYMMDD. I was looking simpler than what you posted.

I tried running the SSRS on the domain account and I get the same result. Additionally, I tried using OLEDB but also ended up with the same result.

Does anyone...

I switched the service to use a domain admin account. I know get the following message:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'BPMF41'....

The report service is set to use the local service account. I am also able to navigate to the directory that has the text file without having to put in...

Do you have a better solutions?

-Dave

I subtracted 8 hours using a dateadd(hh,-8, column).

I figured it out.

Thank you.

I seemed to have fixed it. The issue was really cheesy. Even though it said the report server virtual directory, it wasn't. So after I created it, everything started popping...

Hi Gift:

I tried all three a none of them worked. I think what I'll do is apply all the latest Microsoft pathes to see if that changes anything. I...

Thanks for your help. I knew there was a better way to do it.

Thanks again:-),

Dave

Thanks! This is what I came up with.

Let me know what you think.

WHERE dtStartTimeStamp >= CONVERT(varchar(10),DATEADD(day,-1, GETDATE()),20) + ' 00:00:00.000' AND dtStartTimeStamp <= CONVERT(varchar(10),DATEADD(day,-1, GETDATE()),20) + ' 23:59:59.000'

That's what I was looking for. I think I can manage using Windows scheduler.

Thanks for you help.

Dave:-)

It is working. Thanks to all you who participated.