Excellent. Thanks Elliott and John. I set DelayValidation to True for the package and that fixed my problem.

Thanks for the quick response!

Sushant, Gosta,

Thanks for the ideas. In this case the business users are used to opening the output Excel files on a fileshare. I don't want to change their...

Obviously a valid point. I need to move an old process off of SQL 2000 and it uses DTS packages and VB scripts. I kind of challenged myself...

Thanks for that advice. I will read those articles. We also don't normally install Office components (even drivers) on prod SQL boxes so I'm a little concerned about...

I was able to make this work with OPENROWSET.

1. Download and install the Office 2007 connectivity components - http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

2. Create and save an excel spreadsheet with column headers...

Thanks. I don't know vbscript but that sounds like a simple solution.

I edited the path in your sPath and Saveas statements like this:

Set oXLS = CreateObject("Excel.Application")

sPath = "c:\File.csv"

oXLS.Workbooks.Open sPath

oXLS.ActiveWorkbook.Saveas...

Those are good ideas. Replication might be the answer.

Thanks. We use Red Gate SQL Backup but I don't think it has an object level recovery option.

Yes, that's really it. The solution might be to restore the full backup from A onto B with a different temp name. Then truncate the reporting tables at...

Ok. It sounds like file/filegroup restores are not the solution I need.

I am going to create another thread describing my scenario. Feel free to comment on it!

thanks

Thanks for the response. So you always have to restore the primary filegroup and can optionally restore the other filegroups.

So in my example, to only restore the reporting tables,...

Thanks for the reply. I talked to one of our developers about that. She thinks your suggestion would work in code but I was looking for something that...

Excellent script. I needed to drop most of the tables in database, in RI order. This is exactly what I need.

Thanks!

Hi,

I'd love to use your format file builder. I am running it on a SQL 2005 instance. I was able to create the stored proc but at run...

I have Prevent Failback selected which is the value we use on all our clusters. The thing I can't believe is no errors are logged. There is the...