One other thing you might want to try. Use the 'Export Data' function in SSMS to export something from SQL Server to an excel spreadsheet. Be sure to...

Thanks Matt. That's a much better way to explain it.

Right. Hence the words of caution. The update statement must be written deterministically or you'll end up with the situation you described in your example.

Check the first example in the 'Best Practices' section for the Update statement from msdn:

Update (Transact-SQL) - Link to the MSDN page

Your example is very similar to the one following...

Thanks again. Should have figured there was a catalog view but didn't know about it either. Based on the view suggested, the OP may find the following helpful:

Select

schema_name(so.schema_id)...

Thanks! Didn't know about that function.

Right click the table or column and select properties. Look in the extended properties.

If the database has a diagram, check the description field in the properties of...

You're quite welcome. Happy to help.

Three steps:

1. Set up a variable to hold the changed file name. For this example...

Your description is very abstract. It's not clear what you're trying to have SSIS accomplish. You're more likely to be successful in getting help if you follow the...

It would help to have some test data (see referenced article).

But here is something to check. You're not relating your maximum asset date to the pr_id that each date...

I think there's still a bit missing from the last part of your query. The final join to your max query is missing the ON.

Some DDL for the tables...

I don't see a SET statement or a FROM statement. I'd suggest checking your update in SSMS...

Check the approaches discussed here:

http://www.sqlservercentral.com/Forums/Topic560772-148-1.aspx

Good suggestion. I was limiting my thinking to file system storage with users opening the package to run it.