First post here so go easy... I'm a part time database developer who's recently inherited a database in our company from a DB expert who was recently laid off. So much for background.

I'm working on replacing some DTS packages in the database that pulled data from a DB2 source to a new Oracle data source. I can create a DTS package to copy data from the DSN connected to Oracle to a table within our existing SQL2K database. The DTS package runs without any issues and creates the desired results table in the SQL2K DB.

But when I go into the DTS designer window and try to open the task that copies said data from the DSN connection to the SQL2K connection, Enterprise Manager locks up and I have to force it closed.

Has anyone run into this before, and/or could anyone point me in the right direction as to how to debug this issue?