Can you post your SELECT statement?

How are you handling when more than one column's value is updated?

Yep, that's clear. I understand what your stored procedure is trying to do. What I'm unclear on is what you are wanting help with. What is your...

No problem, glad to help.

I'm not clear on what you want to do. Can you provide an example of what you want your SP to return given a specific input?

Use ROW_NUMBER().

OK, you're close, but now quite there. I should have expanded my explanation a bit in my previous post. Here's what I did to get my example to...

For what it's worth, I third the motion to see this in an article. Have you done any time/performance comparisons on this method versus the SCD transformation?

Where do you get this error? In the OLE DB Source component?

I would create a package level (or scope it to the data flow) variable of type int and set to zero. The code in the Script Transformation will use...

Have you ever been able to connect to this SQL Instance? Are you the SQL administrator?

You could pull this off with SQL Server profiler along with some well written queries to pull the server level performance metrics. As far as a third party tool,...

So is this happening in a data flow? Are you using an OLE DB Source? I had a similar problem pulling data from Teradata into SQL Server. ...

This sounds an aweful lot like a homework question. Why don't you post the table DDL and the SQL code that you've written so far so we can help...

Add a Derived Column Transformation to your dataflow to hold the Identity value, default it to zero. Add a Script Transformation and increment the ID value in the script.

Just...