use a for each loop using the for each file in folder and a script task inside the loop to examine the file names then set a boolean variable if...

Thanks Michael - I overlooked something earlier that your comments led me back to.

Have a great day.

OK

I did find a posting indicating DDL trigger would work but I can't find the DDL event to use. Unless it falls under a different name. I tried Truncate_Table and...

Peter, thanks for the acknowledgement on this, thought it was just me. Anyone have a suggestion on this?

- tom

We want a data warehouse for all data that could in any way be reported on together.

I work for an airline and flight data should be able to be queried...

mhilbrink

thanks for the reply.

After reviewing this a bit more and reading my new Ralph Kimball dimensional modeling book I realized I was overthinking this and kept trying to apply some...

Hey JV I'm not sure about creating a datasource in mgnt studio. If I select script - create to - new query window on the adventrue works data sources I...

You could try using the profiler to capture the exact statement being processed, maybe that will reveal something.

Thanks Michael, that worked perfect!