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.

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...