Add a computed persisted int column, add index and join on that?

Is this a run-time error or a validation error?

When you recreated the package in 2008, did you do it from scratch, or did you try to reuse/copy/whatever bits of your...

I know what an IDENTITY column is, of course.

It seems that you are doing ETL from a source...

...Or you could just remove the IDENTITY definition from the target table 🙂

PurpleLady (6/5/2014)

---

Yes - Integration Services, Data Tools, complete Management Tools, and the Client Tools SDK also. I have at least a dozen other packages that are running on the server....

Is Integration Services installed on the server?

I can get that exact error by doing something like this:

declare @sTime varchar(5) = ' 2359'

select convert(smalldatetime, stuff(@sTime, 3, 0, ':'))

So I'm wondering whether there might be some dodgy...

.. you could also consider using a File System Task for doing the copy.

What do the cmd files do?

Please post the text of the error message.

Put everything that depends on the file's presence in the FEL container - so that appears to be all tasks.

Your file-existence-check script is rendered superfluous.

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.