So the SQL command text is in a variable. How are you executing the command?

--edit

Are you executing the command through the use of an Expression?

A single package will do the job for you. An EXECUTE SQL task can be used to run the sp's. Followed by one or more dataflow tasks to export the...

Where are you entering the text of the SQL query containing the variable?

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.