Wow, you just got a cool new name! 😀

Well done on solving that one by yourself. My solution would have worked too though - at no point did I mention deleting dups, all I said was 'processing' them,...

A variant of the temp table method is probably still the easiest for you.

Bring all the data into a temp table, run a query to identify & process the dups...

I think you might need to MULTICAST to enable the 'reuse' you are after ...

This sounds like a pure SQL question, not SSIS? Anyhow, there is a way, using Common Table Expressions (or CTEs).

Using your example, it would be something like:

With Data as

(select productname,...

I think I detect a hint of sarcasm 🙂

Good luck - please post back if you find the solution.

But did you try changing the datatype?

Assuming that the two tables are both in SQL Server already, just use an EXECUTE SQL task containing the relevant UPDATE command ... Seems a bit too easy - am...

Are you able to rename the dtsx file from Windows Explorer? We need to find out whether the problem is with the package file itself, or with a file that...

Maybe it would help people here if you could post the code fragment which generates the error.

I've found the following suggestions - just quoting what I've found, no guarantees.

1) Install SP2 of SQL Server 2005

2) Register "(path)\Program Files\Microsoft SQL Server\90\DTS\Binn\DtsConn.DLL" using RegSvr32.exe.

That's nothing. You should see me with a hangover:-)

Is this related to SSIS?

Yes - you can assign the result of an execute SQL task such as

SELECT COUNT(ID) FROM TABLE

directly to a variable.