Jeff's suggestion is a good one. Aggregation in SSIS is a blocking transformation and should be avoided if possible. It's also slower than the SQL Server database engine.

SuzSQL (6/3/2014)

---

My situation was not a huge data load but instead was going to load worksheets from the excel to temporary tables and perform some calcs and return. Data...

I suggest you change your approach slightly.

Create a FOREACH container which executes for every occurrence of the file you want to process. It will therefore execute either once or not...

tlrsekar 23727 (6/3/2014)

---

Hi

Thanks for reply, Attached Image, The Last column is my target output which is required.

In image in For MEC department starts with fresh summary since previous summary +...

How are you ordering the data? It's not clear from the sample.

Jason-299789 (5/29/2014)

---

Thanks for the reply Phil. I would agree about setting them to a max size and leaving it, but we have no control over the database. It...

Jason-299789 (5/29/2014)

---

I am working for a company that has a 3rd party vendor application.

The Table that having an ALTER Column run against it is a 300 column heap...

How is your scripting?

If you put your results into an object variable, you can use a single script task to iterate around the results and do all the file manipulation...

My guess would be that you'd chosen not to display known file extensions in Explorer -...

emps.txt.txt?

It's probably irrelevant, but do you realise that your variable is called 'FileExits' in the code, rather than 'FileExists'?

I'm running out of ideas, sorry. This is so simple, it should...

Looks like VB to me and...

No problem. And if you want to ignore the time component, you might like to use

dateadd(d,-7,cast(getdate() as date))

instead.

Yes - add it to the WHERE bit:

WHERE [existing conditions]

AND STAGE1.[STAGE.Completion_Date] > dateadd(d,-7,getdate())

Check the project properties under debugging and set 'Run 64 Bit Runtime' to false. Then try again.