I think I got it! Phil pointed me in the right direction. When I run it (Start without Debugging) in BIDS it processes with a file there and finishes running...

Phil Parkin (7/21/2011)

---

If a foreach loop has nothing to process, execution transfers to the next task. So I suspect that there is something in the logic of your package which...

Thanks steveb. I was thinking the same. I am working on a VBScript to do this. I rarely write VBScript so I was hoping to accomplish via the FEL object.

What about creating a new role called "db_tablecreator" and issuing a "GRANT CREATE TABLE TO db_tablecreator"? Does this allow them to drop tables?

I will implement the trigger anyway for general...

Well... Not sure what the cause is but running a "checkpoint" manually causes it to revert to zero and stops the messages in the event log. I also tested one...

Thanks. That works perfectly. A little odd that the TOP statement is before the variable and not right before the column/ result list.

Because I get an error :

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'TOP'.

Anyone have a hint on how to include the "TOP x" function in this process?:

DECLARE @sql NVARCHAR(100),

...

Thank You Very Much. Works Great!

So I am looking at the "Stuff" version of this solution and discovered that the length of the submitted value MUST be 13 characters. Any shorter and an "out-of-range" error...

No apologies needed "SwePeso". Your post was very helpful. I will take a closer look at it as I venture into the performance part of this. The post was to...

Thanks to everyone who replied and especially Thank you to drew.allen who led me in the direction that produced that result I was looking for. All I had to change...

Thanks for taking the time to read and post Willem. I cannot find any documentation that explains how to use a conditional split. It looks like a process task that...

OK. So I put each column evaluation in it's own "Data Flow" task. Problem solved for the time being. However, I have a new issue. It is a performance tuning...

Have you tried Lookup tables?

Once I figured out how to use lookups, I can't imagine needing to replace values in a derived column object any longer.