That is brilliant Hari. I never thought of jumping to the same report.

It works perfectly in preview mode but when I deploy it, it tells me that the SupporterID...

Thanks, that is the conclusion that I reached too.

There is some way to do it though because Enterprise Policy Management Framework manages to capture cms output to a database. I...

This is very valuable for planning outages. If I put in the time range for last night, can it show me which jobs did not run because the server was...

Very nice. Thanks Derrick! I'll give it a run now.

Howard

Thanks Derrick. I poked around in msdb.dbo.sysjobhistory , msdb.dbo.sysjobs, and msdb.dbo.sysjobsteps but did not find a way to produce the result.

I came up with this which seems to work:

IF OBJECT_ID('tempdb..#temp') IS NOT NULL

BEGIN

DROP TABLE #temp

END

SELECT SD.Name, CONVERT(varchar(12), MAX(Backup_Finish_Date), 101) AS Last_Backup

,Type, convert (varchar(5),DATEDIFF(d, MAX(Backup_Finish_Date), GETDATE())) AS Days_Since_Last

INTO #temp FROM MSDB.dbo.BackupSet...

Thanks for responding Gail. I'll do it the preferred way. Just looking to gain knowledge.

Thanks Luke. I see where you are going with this. The report is in SSRS 2008 but I'll give it a try.

Yes, I have a header that lists...

Thanks RB, it is very interesting. I'll give it a try. Event handlers and logging are things I've been wanting to learn about.

We don't have any users who have access to the flat file. I guess we could easily bring the value into a table and eliminate an external point of...

I'm taking a DTS package and converting it to SSIS. The original package used a flat file source. I think that they want to allow users who don't have...

Thanks so much or the help. This task is working perfectly now!

Thanks da-zero. I see, == is used because both sides are equal to each other.

I'll build a msgbox to find out for sure.

I think that I'm getting close.

I made a system variable in SSIS that evaluates as an expression which is User::ActiveSchema

Than added this VB script task code:

Dim file As String

...

First try... updated below