Yes, you have to install HIS on each PC that runs instance of SQL servers.  If you do not run clustered SQL server, it can be simple to install and...

Well, Krista -

let me recommend you to this better site which has lots of discussion on using DB2 inside SSIS. You should be able to find helpful info there.

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=Db2&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80

Let...

I am working on copmletely rewriting DTS 2000 to SSIS package from the scratch. I have been dealing with sending data to DB2/AS400.  I contacted with microsoft support and they said that...