What's the error?

Do you have any date time columns in the source table? Those can wreak all kinds of havoc when you bring them back to SQL Server.

What do you mean by this:

If I can't use the Linked Server I can't perform a merge or an OUTER JOIN what combination of task could I use to accomplish...

The path is fine. It finds everything just fine. The only issue is that the one rollover file is blank.

Bumping in case anyone who might have a solution missed it when it was posted...

The file is empty. Opening it up in Profiler reminds me of this. Opening a prior one in profiler then telling it to get the next (blank) one it doesn't...

I'm using one of Michael's versions and I'm getting NULL values when there is a date and the time is 0.

i.e.:

last_run_datelast_run_timeLastRunDateTime

20081118 0 ...

While it is generally a good idea to have tempdb spread across multiple files/drives, this would not directly address the poster's issue.

You have a query or queries that are requiring significant space in tempdb. Since tempdb is recreated each time you restart the server it will always start out at its...

Howard: upper right hand corner of the code block is a set of icons. Second one in (the two pieces of paper) is "copy to clipboard". I just copied this...

Thanks everyone. I'll be taking bits and pieces of these for our diagnostics/reporting.

I'm the exception to the rule. We have processes that run monthly, quarterly and annually. We also have some mandated auditing. So we keep roughly one month of backup data...

Lowell, what I do is pretty basic - on Tuesday start of day, off Thursday end of day (or thereabouts). Sometimes I'll turn users off towards the end of the...

I have a comparable scenario adn that's exactly what I'm doing. Job enables the login when I want them to have access, disables it otherwise. You may want to run...

Yeah, I stumbled on that just before you posted (see above). That was indeed...

Urgh. Was poking around looking at a few things on the report server itself and noticed that there was a 'Parameters" tab. Looked there and it was holding on to...