Opening DTS package on a cloned server

Question

I have a Virtual cloned machine on SQL 2008, I notice that whenever I try to open a DTS package remotely I get the error below but if I try it from a physical machine it looks fine, it looks to me like something somewhere needs to be updated, I have a feeling that one of the meta data objects on the database is still referring to another server where this VM was cloned from.

The error is as follows:

 

TITLE: Open DTS 2000 Package
------------------------------

here were errors loading package "package name":

[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. (Microsoft.SqlServer.DtsObjectExplorerUI)

 

 

Answer 1

Did u installed SQL Server 2008 SP1 on the virtual machine.

---

Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

Answer 2

Hi MrFlinstone,

You want to migrate data from an instance of SQL Server 2000 to an instance of SQL Server 2008, right?

If so, I recommend that you use SQL Server Integration Service 2008 to accomplish this work.

If you still want to use this package of DTS 2000, please refers to: http://blogs.technet.com/mdegre/archive/2009/07/29/migration-sql-server-2000-dts-to-ssis-2005-2008.aspx

Regards,
Tom Li - MSFT