Do you want to process the rows in ascending date order?

If your source has rows 1, 2, 3 and 4, what will be in your calculated table?

Will it be

1-2

3-4

or

1-2

2-3

3-4

?

Please describe what you mean by 'difference'.

Eg, if

row a contains: 'Fred', 12, 1980

row b contains: 'Bill', 150, 27

what would the difference be?

Also, what order are your rows in?

Please explain...

Create an OLEDB connection to your database.

Add an Execute SQL task - specify the above connection.

Click on Expressions in the task editor and then expand the Expressions item to get...

Difficult to help without knowing a bit more.

My advice would be to focus on the first error - resolving it may fix some of those that occur after it. What...

The ALTER TABLE requirement continues to puzzle me. Anyhow, now that I understand better what you are trying to achieve, here is how I would do it:

1) Create a staging...

I am afraid that I do not know about your error message.

But I have never found anything in an ActiveX task that cannot be accomplished in a script task and...

It's no mystery - you have to rewrite your code using .NET syntax. I'm afraid that you have some learning to do, as I doubt that people here have the...

You need to rewrite your VBScript code in VB.NET - the syntax and commands are quite different. I'm afraid that cutting and pasting just won't work.

Phil

Can I just confirm what the underlying business requirement is here? Is it that there are constant amendments to an Excel spreadsheet of employee data and you want these amendments...

haha, I was wondering the same and was hoping to draw out the answer gently,...

Great tip - I did not know about that ... looks perfect for this.

So the sources are being updated continuously? Or just from time to time? You may encounter some locking problems.

One approach could be to move the source file to another folder,...

Maybe you could create a single file containing all the SQL first:

If Exist All_Files.sql Del All_Files.sql

Copy *.sql All_Files.sql /y

and then just execute All_Files.sql to save iterating round - not sure...

When you create a connection to the source file, using the Flat File Connection Manager Editor', select 'Advanced' - you can type in a caret directly as the column delimiter.

Phil