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.

Between source and destination.

Nice solution Jeff.

That's not as easy as you've made it sound - unless you know a method I haven't thought...

--Oops, please ignore!

John Rowan (11/6/2009)

---

Good to hear that you're up and running Tim. I agree, it's simple when you know how, but I'm not sure I'd call using a script task...

I already thought that SSIS was tough enough in English, but this takes it to another level 😀

Looks like a problem on the AS/400 side - can you give more...

I have a couple of Excel suggestions for you:

1) When entering numeric data that you want to to be treated as text, enter a single quote as your 1st character....

Can you post the exact syntax of your expression field - sounds like it may need a tweak.