Home > SSIS Best Practices > Missing Assembly System.EnterpriseServices

Missing Assembly System.EnterpriseServices

Fantastic!  Great work tracking that down.

A.

From: Sherry
Sent: Thursday, June 10, 2010 7:58 AM

After much googling and reading, trial and error, I finally found the solution. In the assembly folder (C:\WINDOWS\assembly), we are missing the version 2 of the assembly. I copied it from the Microsoft.NET Farmework folder (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727), and re-started the Integration Services from SQL Server Configuration Manager.

clip_image002

Now we should be able to browse the packages from management studio, and also use the Import/export wizard there.

clip_image004

B and C – let me know if you still have issue with browsing MSDB in the SQL management studio.

(P.S. – The missing assembly System.EnterpriseServices is possibly caused by 1) The SQL Server was installed on E drive other than C drive. 2) The Integration services was installed after the Microsoft.NET Framework was installed.)

Sherry

From: Sherry
Sent: Wednesday, June 09, 2010 6:14 PM
clip_image006

It looks like I can import package into the File System, but not the MSDB database, which is supposed to be the same MSDB as the system database in the default sql server instance.

Sherry

From: Sherry
Sent: Wednesday, June 09, 2010 6:06 PM

I went into add/remove program, and selected Integration Services.

It actually reported that the integration services is installed. I just went into SQL Server Configuration Mgr. It looks that it is installed and is running in automatic mode.

clip_image008

Sherry

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: